Stack Overflow
Stack Overflow

Questions tagged [pervasive]

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

Actian Zen Embedded Database is a hybrid-NoSQL/relational database for superfast transactions and standard SQL access.

Actian Zen offers full security, encryption, management and monitoring tools, plus a host of other features.

Actian Zen Embedded database is built for environments where users don’t have the resources to manage a database.

Actian Zen enables ISVs to take advantage of new hardware architecture, OS platforms, and computing environments (64-bit, multi-core, VM, Cloud) without application changes.

Official product documenation can be found here.

Actian forum for Actian Zen can be found here.

286 questions
0
votes
1 answer

What does back to back table references mean in SQL from clause

I am looking at a query from crystal reports and it shows a table name immediately followed by a table name. see below if that didn't make sense but I am trying to understand what this syntax is/does? thank you in advance for any insight select *…
SkylarP
  • 39
  • 1
  • 8
0
votes
1 answer

With Powershell create new Pervasive ODBC with new database

I would like to create in Powershell a 32 bits ODBC connection to a Pervasive Database. I have the following that works: Add-OdbcDsn -Name "dbcon" -DriverName "Pervasive ODBC Engine Interface" -DsnType "User" -Platform "32-bit" -SetPropertyValue…
foxtrot
  • 1,056
  • 1
  • 8
  • 24
0
votes
1 answer

Creating a DSNless connection to Pervasive in VBA

I'm very new at connecting to databases so I apologise if I'm not familiar with some of the terminology. I would like to open up a DSNless connection to the pervasive database using VBA and I'm running into various issues. The forums that I have…
Deacan
  • 1
  • 1
  • 1
0
votes
1 answer

How can I combine data from the same table that has a different flag?

I'm trying to pull data that contains a job number, order number, part number and description. Some rows in my table are flagged as 'L' for Labor and 'M' for Material. L flagged rows can be taken literally, hours_worked = total hours on job, labor =…
jakkej14
  • 1
0
votes
1 answer

Syntax issues with pervasive SQL if statement used to determine left join on clause

Back Story: I am looking to do a left join based on if a condition is true with an if statement. However if it is false, I want to still join the said table in, but with the same columns or with a new set of columns. This query is being wrote for a…
Megadeth9001
  • 1
  • 1
0
votes
1 answer

Pervasive SQL - Add a Rank Column to a Sorted Recordset

In Pervasive 13, I'm looking for a way to add a rank column to a sorted record set. For example, let's pretend that I have a customer table that has a field called profit (which is maintained to indicate the total profit from each customer). Instead…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
0
votes
2 answers

Dynamic SQL statement return value using the current target connection

I'm currently creating my first real life project in Pervasive. The task is to map a certain XML structure containing orders (as in shops and products) to 3 tables I created myself. These tables rest inside a MS-SQL-Server instance. All of the…
0xCAFEBABE
  • 5,576
  • 5
  • 34
  • 59
0
votes
1 answer

Does Pervasive Have a SQL Function for URL Encoding?

I've written a query that builds some URLs to an intranet site, but some of the URLs don't work because they contain special characters that need to be URL encoded. I'm trying to avoid writing a script (outside of SQL) to do the URL encoding; I'd…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
0
votes
1 answer

How to get a list of dates in Pervasive SQL

Our time & attendance database is a Pervasive/Actian Zen database. What I'm trying to do is create a query that just lists the next 14 days from today. I'll then cross apply this list of dates with employee records so that in effect I have a list of…
David
  • 59
  • 1
  • 7
0
votes
1 answer

Connect to Pervasive Database using Python pyodbc

I'm trying to connect to a Pervasive database using pyodbc. Below is the code I've tried: import pyodbc server = '10.10.10.01' database = 'RMS' username = 'test' password = 'test123' conn = pyodbc.connect(f'DRIVER=Pervasive ODBC…
J. Skinner
  • 309
  • 1
  • 8
  • 17
0
votes
1 answer

Is there some way to ascertain if the tableadapters underlying data has changed

I am retrieving data from my database using a TableAdapter. I was wondering if there is some way I can tell (or be informed) that the data has changed and I therefore need to do another Fill? That way I can just Fill on demand rather than every time…
Matt Wilko
  • 26,994
  • 10
  • 93
  • 143
0
votes
1 answer

Help with SQL INNER JOIN statement

I have 2 tables , one showing me customer addresses and one other table showing all the order data. i would like to query the two tables using a JOIN so that i can get a result set shwoing me all the email addresses for customers that have not…
seb
  • 151
  • 1
  • 4
  • 7
0
votes
1 answer

Pervasive SQL v10, Inner Join doesn't work

i am trying to join to tables in Pervasive SQL. select GUID, b.BankName from Ad INNER JOIN AdBankKto b ON b.AdGUID = Ad.GUID But i always get an error: [LNA][Pervasive][ODBC Engine Interface]Error in expression: GUID If i delete GUI, i get this…
krejale
  • 25
  • 3
0
votes
1 answer

Actian/Pervasive SQL and Date Variables

How are date variables declared and used in Actian Zen/Pervasive ? How do i fix this CREATE proc test1 () returns(TranDate integer, GLAcntNumber integer , Net decimal(39,19)) as BEGIN DECLARE :StartDate DATE ; SELECT CAST('2021-01-01' AS…
Habib
  • 70
  • 7
0
votes
1 answer

How can I find a Substring in an SQl-Query=

select * from "ParaListen" where Auftrag='235829/PAOrtsA' How can I find a certain "Substring" in an Pervasive-statement? Select select * from "ParaListen" where substr(Auftrag,8,?)='PAOrtsA' I mean: which function shows the rest of the string…
Max Lindner
  • 171
  • 1
  • 1
  • 7
1 2 3
…
19 20