Stack Overflow
Stack Overflow

Questions tagged [pervasive-sql]

Pervasive PSQL is an ACID-compliant DBMS

It is optimized for embedding in applications and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). It is also optimized for software as a service (SaaS) deployment due to a file-based architecture enabling partitioning of data for multitenancy needs.

Applications can store the data and the relationships in tables in a relational model (RDBMS) or store the data in a schema-less way with no fixed data model (key-value store).

165 questions
7
votes
3 answers

SQL Column Name wildcard

I have a table with 30+ fields and I want to quickly narrow my selection down to all fields where column name start with 'Flag'. select * Like Flag% from Table1
Kevin Dion
  • 93
  • 1
  • 1
  • 5
7
votes
7 answers

How can I Ascertain the structure for each person from a self referencing table

I have the following tables: Employees ------------- ClockNo int CostCentre varchar Department int and Departments ------------- DepartmentCode int CostCentreCode varchar Parent int Departments can have other departments as…
Matt Wilko
  • 26,994
  • 10
  • 93
  • 143
6
votes
2 answers

How to convert °& to readable date?

I am converting a database that was made in the 80's and it seems that the date for some tables is stored as characters. There are 2 columns of data. The first column has data formatted like this: °& C2 024 The second column is a plain text…
Peter Black
  • 1,142
  • 1
  • 11
  • 29
5
votes
2 answers

Export query result in Pervasive to txt / csv file

I'm using Pervasive 10 with PCC (Pervasive Control Center) and I need to export a lot of results (over 100 000) to a TXT file.I know it's possible "Execute in Text" but this feature does not work for me because after exporting about 20 000 records…
Timoteus
  • 53
  • 1
  • 7
4
votes
1 answer

How to add database to pervasive sql Control Center?

I've never touched PervasiveSql before and now I have a bunch of .ddf and .Btr files. I read that all I had to do was create a new database in the control center and point to the folder that contains these files. When I do this and look at the…
Chris
  • 2,953
  • 10
  • 48
  • 118
4
votes
7 answers

SQL statement with LIKE

I would like to select all records that have an underscore character in their 11th character, so i try this: SELECT * FROM "BOM_SUB_LEVEL" where TOP_CODE like '%%%%%%%%%%_%%%' but this doesnt work as expected, can someone help?
chicane
  • 1,991
  • 3
  • 19
  • 15
3
votes
5 answers

How to convert REAL48 float into a double

I am connecting to a Pervasive SQL database which splits some data over two fields. DOUBLE fields are actually split into fieldName_1 and fieldName_2 where _1 is a 2 byte int and _2 is a 4 byte int. I want to take these values and convert them using…
Alexander Holsgrove
  • 1,795
  • 3
  • 25
  • 54
3
votes
1 answer

Pervasive SQL ADO.NET data provider

I have an asp.net, c# application using MSSQL 2008 server. At some point, i also want to insert some data into a pervasive v10 database. Was looking for the pervasive data provider…
rhys
  • 35
  • 2
  • 4
3
votes
1 answer

Using UnixODBC and FreeTDS to connect to Pervasive SQL server in ubuntu?

I am trying to connect to a Pervasive Sql Server which is running on Windows 10 from an Ubuntu 14.04.4 server. I am using the following services to try connect to the server: FreeTDS unixODBC Before starting I tried to ping the host machine from…
Rambling-Monkey
  • 97
  • 6
3
votes
1 answer

Select max date row from results

Using Pervasive SQL, I have a result set: Tp_No Name State Eff_Date Actual Billed 1006 ABC TN 2006-07-01 .1 .5 1006 ABC TN 2008-02-15 .27 .6 1006 ABC …
jeremib
  • 741
  • 2
  • 7
  • 17
3
votes
1 answer

How to load Pervasive data files?

I have a requirement to extract the data from the database files of Pervasive-SQL 7 into CSV format. I was given a Zip archive containing an application executable (probably developed VB6) and a folder with the data files, and only told that the app…
Steve F
  • 1,527
  • 1
  • 29
  • 55
2
votes
4 answers

Year, Month, and Day parameters describe an un-representable DateTime how to ignore

I am using ODBC to read data from a pervasive PSQL database and in some scenarios, the date column can contain 00/00/0000 date. I don't really care about invalid dates so is there some way I can convert all of these un-representable dates into Null…
Matt Wilko
  • 26,994
  • 10
  • 93
  • 143
2
votes
1 answer

I have old .DTA Files and .DDF Files... now what?

First time poster here, so be gentle... I am completely stuck, I have been given the task of importing some old .DTA files into tables in SSMS so we can run queries off of them. Being brand new to .dta formats, I did some digging and this is the…
MichelleSQL
  • 21
  • 2
2
votes
2 answers

SQL Case() casts results as integer

Working with a Pervasive SQL database, I have a complex SQL SELECT statement that contains the following: CASE l."Position" WHEN 3 THEN "PIC" WHEN 4 THEN "SIC" WHEN 22 THEN "FA" ELSE '' END AS…
Stephen R
  • 3,512
  • 1
  • 28
  • 45
2
votes
1 answer

Pervasive Date Comparison

I am a newbie to Pervasive and I am trying to fetch all records from Patient table where the Date of birth of Patient is not '11/30/0002' The Birthdate is stored in MM/DD/YYYY format in the system Requesting your assistance
Mayur K
  • 21
  • 2
1
2 3
…
10 11