Questions tagged [pervasive]

Pervasive PSQL is an ACID-compliant DBMS developed by Actian Corporation.

0
votes
0answers
36 views

What's the most efficient way to do a case-insensitive like expression?

In Pervasive v13, is there a "more performant" way to perform a case-insensitive like expression than is shown below? select * from table_name where upper(field_name) like '%TEST%' The UPPER ...
0
votes
1answer
35 views

Pervasive SQL Java Database Name

EDIT: I also tried the standard java connection using this answer: Creating Java Connector for pervasive the main problem here is that it works with Demodata, but the name of the database I need to ...
0
votes
1answer
14 views

How to query a Pervasive v13 database from a Docker Container?

How can you query a Pervasive v13 database from an application that's running inside a docker container? It would seem you'd have to install the pervasive sql client inside the docker container to ...
-3
votes
1answer
19 views

Pervasive SQL: Can a client send multiple SQL Statements in one Database Request?

From a client-application, is it possible to send multiple SQL statements at once to PSQ v13? I have a situation where I'd like to send both a delete statement and an insert statement in one call via ...
0
votes
0answers
25 views

odbc_connect can't find PervasiveSQL driver when running as www-data (apache)

I'm trying to connect to a PervasiveSQL 11 (running on Windows) via PHP 7 on Ubuntu. But, the odbc_connect function fails with the following error message Warning: odbc_connect(): SQL error: [...
0
votes
0answers
34 views

Connect to pervasive database with pyodbc

I am having trouble connecting to our database using PyODBC. Code is below: pyodbc.connect('Driver={Pervasive ODBC Client Interface};ServerName=GSSERVER;dbq=@wpiglobal;') I get this error: ...
0
votes
0answers
41 views

How do I access *.xq4 and *.xq5 suffix files?

For a project I am required to access the data stored by the program. The software writes the data to respectively a *.xq4-file and a *.xq5-file. I would like to access or extract the data from the ...
1
vote
1answer
36 views

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 ...
1
vote
0answers
61 views

How to read dates in Pervasive SQL?

I'm working with a client who is using a Pervasive SQL database, and trying to understand how their database is structured. The problem is that my client isn't aware of how the database was setup, and ...
1
vote
1answer
42 views

Does Pervasive Database have a Scheduler?

Does the Pervasive Control Center (PCC) provide a scheduler? I want to run a sql statement on a schedule. Does Pervasive database offer any type of built-in scheduler, where I can add a statement and ...
0
votes
0answers
56 views

Connect to ODBC Database with Java (not Access)

I have an ODBC database on Windows Server 2008. Typically I use Access or PHP when I want to work with it, but for reasons I need to connect to it with Java now and it's proving more difficult than I ...
2
votes
1answer
23 views

Pervasive SQL ignoring Order By after Group By

I have a query where i need to group sales by sales rep then client (and currently it is ordered alphabetically sales rep then client) that part work perfectly, but the request recently came that i ...
0
votes
0answers
99 views

Ignore Locked Records During Pervasive PSQL Update Statement

Is there way to tell Pervasive PSQL to ignore locked records during an standard SQL Update Statement? I have an update statement that needs to run daily on a Pervasive PSQL 11 SP3 database (that ...
0
votes
0answers
128 views

Pervasive The OLE DB provider “MSDASQL” for linked server reported an error. The provider reported an unexpected catastrophic failure.

MSSQL 2016 link to a Pervasive server. It can see the DBs on the Pervasive database, and tables but when you do a select SELECT * FROM OPENQUERY(LinkedServer, 'SELECT * FROM DB....
0
votes
1answer
174 views

“Cannot define field more than once” error when opening Pervasive table in MS Access

A few months ago, I updated a system that uses Pervasive v11. Only after that update, I started having problems with MS Access (2003 and 2016 tested) failing to link or import certain Pervasive tables ...
0
votes
1answer
36 views

Pervasive SQL reuses a deleted primary key

I came across a very odd behavior of PSQL (v11) recently: If I create a table with an identity column, add some records and then delete the last row, this rows key will be reused! create table "...
0
votes
1answer
43 views

PervasiveSQL - Inserting/Updating record inside and If Else statement

G'day. I'm trying to create a basic function which checks for the number of records matching a certain criteria. If there are none then it performs an insert and returns returns 0, otherwise it ...
0
votes
0answers
29 views

Inventory On-Hand Qty

Is it possible for Crystal report to calculate the "AvailableQty" field the way I need it to look? Or a better way. Existing report: ShipDate PartNum Qty On-Hand Pick Shipped ...
1
vote
1answer
26 views

Pervasive PSQL Control Centre / Currency data type

Having issues updating a Pervasive PSQL table using Pervasive Control Centre and wonder if anyone can point me in the right direction. I'm struggling to update a field in the table whose type is '254-...
3
votes
1answer
442 views

SQL Server 20XX - “encryption not supported on the client” when compiling stored procedure with linked server query

Attempting to compile a stored procedure in SSMS, which contains an open query to a linked server. The linked server is connected and in my 'Server Objects/Linked Servers' folder. I can do the open ...
0
votes
3answers
57 views

Pervasive PSQL having trouble with inner join

error CREATE VIEW "V_BACKLOG" AS SELECT JOB_OPERATIONS.JOB, JOB_OPERATIONS.SUFFIX, JOB_OPERATIONS.SEQ, JOB_OPERATIONS.PART, JOB_OPERATIONS.DESCRIPTION, JOB_OPERATIONS.ROUTER_SEQ, ...
0
votes
1answer
387 views

Using Crystal Reports in VB.net windows app

I've done much googling and tested various code no avail, so before anyone cries "DUPLICATE" please read the question through. The Scenario: I have a windows form written in VB.net using visual ...
0
votes
1answer
37 views

Pervasive v10 query syntax error

I have a querySELECT WOBOM_ASSY FROM WOBOM WHERE WOBOM_LINE^ = ? AND WOBOM_WOPRE = ? AND WOBOM_WOSUF = ? But I have "WOBOM_LINE^<> Syntax Error". I can use the query in Pervasive v8.
0
votes
1answer
128 views

Retrieve data from Pervasive database used by Magic application

I have a client who has had a developer (who has died since) set him up a Magic eDeveloper application which uses a Pervasive V8 database. Thing is that his licence ran out and the developer is not ...
0
votes
1answer
56 views

Executing a stored procedure on pervasive server

I have a stored procedure on my Pervasive Server called EGC_Expl_BOM_TT and I can execute it with "CALL EGC_Expl_BOM_TT('B-8579-K')" in my SQL query window within Excel, however it will perform the ...
0
votes
2answers
172 views

Pervasive Stored Proceedure with variable

I want to run this code from my query windows inside Excel but I get an error after it completes the first statement. If can run it fine in PCC. I'm assuming I need to create a stored procedure with a ...
1
vote
1answer
298 views

SQL Server 2014 linked server to Pervasive database

I'm trying to create a linked server from SQL Server to a Pervasive database. I have the 64-bit System DSN configured and working: ODBC DSN set-up and setting up the linked server thus: Linked ...
0
votes
1answer
117 views

How do I connect and inserting records into pervasive sql in php

I am working on a PHP project that needs to send data to Pastel. How to connect to pastel's pervasive and insert the records directly for the pastel to use?
0
votes
1answer
153 views

Create Database in PervasiveSQL from Command Line

How do I create a database in PervasiveSQL using the command line. I know how to do it via Control Center, but I would rather create it via the command line. I am working to automate the standup of a ...
0
votes
1answer
18 views

EF6.1.2 code first with 2 navigation properties both are one to zero to one, one works, but the other does not work

I have 3 tables, one is kind of the base table and is big. Then I have an extension table which is also big Then I have a tiny table with only one attribute except for the PK In essence the primary ...
0
votes
1answer
77 views

Insert columns from another table

I'm not sure if I'm going the right way about this but I want to create another table with an auto increment ID. I created another table but how do I add the columns from the first table into the ...
1
vote
1answer
344 views

Pervasive SQL - Get the location of a character within a string

In Pervasive SQL version 11, is there a native function that I can use inside a select clause that will return the index location of a character within a string? I found this: http://help.pervasive....
0
votes
0answers
252 views

Pervasive PSQL v11 - Automate Export Tables to CSV Files?

I am trying to find any free method possible to automate export of Pervasive PSQL tables to CSV files. I can do manual exports from the GUI of the application running on PSQL (Sage 50 in this case). ...
0
votes
0answers
865 views

SQL Server 64-bit ODBC Connection to 32-bit Pervasive SQL v10

I am using the 64-bit version of SQL Server 2016 Express, trying to connect to a 32-bit Pervasive SQL v10 database. I am setting up a Linked Server in SQL Server via ODBC connection, but I am ...
0
votes
0answers
36 views

Simplify many like statements

I have a list of names that are either a company name or a person's name. I have to manually decide if it's a company or a person. I have looked at each row and used a case to decide. If it's a ...
0
votes
0answers
34 views

Pervasive v11: Remove optional paramter in where clause

I am using Pervasive V11. In the following query i have an optional parameter called ModelYear. I would like to exclude it from running in the WHERE clause when it is passed as NULL. SELECT Year,...
0
votes
1answer
75 views

Pervasive-SQL, INNER JOIN with the UNION result

I try to JOIN table with the result return from UNION sub query. But I get syntax error from the query below. Is it possible to achieve such task with Pervasive database? I am using Pervasive v8. ...
0
votes
2answers
77 views

Pervasive PSQL GROUP BY Clause

I have the following following SQL call that I make on a Pervasive V11 database. I'm looking to work it so that I only get one line for each Item Id. SELECT inventory_history.item_id AS '...
0
votes
1answer
168 views

How to find number of tables in a database and size of database Pervasive

I am using Pervasive Control Center v11. How do I find the size of an entire database and the number of tables? The following results in error:'error in expression' SELECT pg_size_pretty( ...
-1
votes
1answer
417 views

How to migrate Pervasive database to SQL Server 2008?

I have a database that runs on Pervasive Control Center Version 11.30.051.000. I want to copy that entire database to a SQL server database bs I dont want to use Pervasive anymore.
0
votes
2answers
57 views

actian JCL example

Does anyone have an example of retrieving data using Actian's JCL to a loosely coupled pervasive database in Java? The database I am connecting to only has DAT files. My goal is to create a link ...
0
votes
1answer
542 views

convert string from MM/DD/YYYY to YYYYMMDD

My date column is stored as a CHAR and in YYYYMMDD format. The string I have to search from this column is in MM/DD/YYYY format. How could I change it to YYYYMMDD. Also if my parametr is passed NULL ...
0
votes
1answer
206 views

How to read the identity of a record inserted into database table with Pervasive SQL?

I am developing a C# Windows Form app and need to insert a record into a table and then read back the identity of the record and pass that identity to another part of the program. See code below. The ...
0
votes
0answers
40 views

Pervasive Exclude paramters when 'NULL' in Ad-Hoc Query

I am passing ad-hoc query from a .NET app to Pervasive v11 PSQL, I believe I cant declare variables outside of a stored procedure and view. Since I don't have the option to create stored procedure and ...
1
vote
0answers
21 views

PCC V10 import lines

PCC V10-have exported the table (MS Excel), identified which transactions are missing and have isolated them in same format as original file. Have saved as .csv with and without headers - wont' import....
0
votes
2answers
384 views

Concat two columns in Where Clause in PSQL v11

SELECT CONCAT(rtrim(Xyz.FirstName), rtrim(Xyz.LastName)) as person from Xyz WHERE Person = ('JohnSmith') The above works but my input parameter would have a space in it for example "John Smith". ...
0
votes
1answer
31 views

Convert vbscript into rapid integration flowlanguage

I'm using Pervasive 9.2 and would like to somehow convert the vbscript into pervasives RIFL language. I want to execute the code during a Process where the f(x) component is executed to run the code. ...
-5
votes
1answer
121 views

How to get all databases in pervasive from C# code? [closed]

I want to list all databases on a server in a dropdownlist using pervasive and c#. Any advice or links for to read about it. Thanks
0
votes
1answer
48 views

SQL (Pervasive) - several columns to one + title columns to data

Is it possible to do a query in sql (Pervasive), to turn a several amount of columns to only one (eg.quantaties by month, to only onde column)? And that the columns titles that disapears turns into ...
0
votes
1answer
18 views

SQL - several columns to one

Is it possible to do a query in sql, to turn a several amount of columns to only one? An example, turn the current database structure: **product_ID | month_A | month_B | month_C** AAAAA | ...