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
1
vote
1 answer

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 server set-up with security set to "Be made without…
Mark McArdle
  • 23
  • 5
1
vote
1 answer

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 PervasiveSQL box for a project I am working on. I…
Sage
  • 4,769
  • 1
  • 21
  • 28
1
vote
1 answer

Get latest exchange rate for all currencies

I have a database with a lot a currencies and each row has a currency, datestamp and the exchange rate. What I would like to have is a query that gets me the latest exchange rate for all the currencies based on the datestamp. I would not like the…
Oskar Kjellin
  • 21,280
  • 10
  • 54
  • 93
1
vote
1 answer

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.com/display/DI1025/InStrRev+Function But, when I…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
1
vote
0 answers

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. I have saved as .txt file, says it imported…
Netts
  • 11
  • 1
1
vote
2 answers

Why do I get an ODBC connection failed error when using UNION ALL in Access?

I'm writing a SQL query in Access 2010 with tables linked to a Pervasive client by ODBC. When I open the tables, the ODBC connection works fine and shows me the values in the table. The query is a series of queries using UNION ALL to merge them…
boilers222
  • 1,901
  • 7
  • 33
  • 71
1
vote
1 answer

Import from Pervasive Database Files

I need to import data from pervasive database to sql server. I have installed pervasive db claient & oledb provider. the pervasive database with me is in file format (folder with .DAT files). I would like to know how to read data from these files.…
Sharjeel Ahmed
  • 285
  • 6
  • 18
1
vote
1 answer

SQL pivot/join table?

This is my actual table... ID SEQ HOURS ROUTER 1 1000 13 Old 1 2000 23 Old 1 3000 17 Old 2 1111 43 New 2 2222 40 …
Waxi
  • 1,641
  • 2
  • 14
  • 20
1
vote
2 answers

SQL query in dire need of optimization

I have this query, which works fine, except it takes a couple of minutes to load. I need help optimizing it so it runs faster and I don't know where to start: SELECT job_header.job, job_header.suffix, job_header.customer, …
Waxi
  • 1,641
  • 2
  • 14
  • 20
1
vote
1 answer

SQL - Joining multiple selects/tables

My first query... SELECT t1.a, t1.b, t1.c, t2.a, t2.b, t2.c FROM t1 LEFT JOIN t2 ON t1.a = t2.a WHERE t1.b = '000000' AND LENGTH(t1.a) > '5' AND t1.c <> 'Y'; My second query... SELECT t1.a, t3.b as testMe FROM t1 LEFT JOIN t3…
Waxi
  • 1,641
  • 2
  • 14
  • 20
1
vote
1 answer

How to connect Pervasive ODBC using PHP on Windows?

I want to Connect Pervasive ODBC using PHP on Windows. Wether we have to download Pervasive client version for same? Whats else we need to download for this?
Akshata
  • 271
  • 2
  • 7
  • 11
1
vote
2 answers

Btrieve Date Integer

this is my question: I'm migrating data from a Btrieve file (.dat) through Pervasive Control Center and there is field type which is defined as integer but is a date and for example the date '31/12/2009' (seen in the legacy system) is view it as the…
Nelson Miranda
  • 5,484
  • 5
  • 33
  • 54
1
vote
1 answer

connection to Pervasive database slow

This has been an on going issue at my place of work. Previously, we had a co-op programming student write us some applications using C# which ran well on his laptop, but once the applications were put to use on different computers, the connection…
exceptional exception
  • 527
  • 7
  • 26
1
vote
2 answers

ODBC connection works through command line, not through apache

I'm trying to connect to a Pervasive 11 DB on a remote system using PHP. The DSN is setup in /etc/odbc.ini. The psql (created by the Pervasive client installer) and www-data user can connect to the remote system using isql -v remote Furthermore,…
HogeBlekker
  • 13
  • 4
1
vote
0 answers

Need a Concatanate By Group Aggregate Command For Pervasive SQL

Suppose I have a table like this: JOB_NUMBER | PART -----------+------------ JOB 1 | PART A JOB 2 | PART B JOB 2 | PART C JOB 4 | PART D JOB 3 | PART E In my Pervasive database I need to…
Mike Sportsman
  • 120
  • 2
  • 10
1 2 3
…
19 20