I am about to start using transactions in PSQL 9.5 for the first time.
Are there any limitations on the number of tables or the number of rows
or the number of changes that can be involved in a transaction? Thanks.

In the version 9 SQL Engine Reference the description of START
TRANSACTION on page 203 states the following.
"Within the ODBC standard, SQLSetConnectOption is used to specify
whether each statement is in its own transaction or the application

I need to convert some DDFs from version 6 to something that PSQL
version 9 can read. Does anyone know of a utility (preferable free)
that will do this? Thanks

I am trying to create the following trigger.
CREATE TRIGGER paRelateLinkInsert
AFTER INSERT ON paRelate
FOR EACH ROW

We have a customer that uses Novell Clustered servers, when trying run
a conversion on the data from an older version of our software the
application returns a Status 11 filename is invalid.  This error
occurs on some not all of the files to be converted.

I have hundreds of NDB files, and I need a way to see whats in them?
Is there a program or reader that would work?

I have a pervasive 8.5 implementation that is throwing btrieve 3103 errors
intermittently.  It is running on a windows box and has a user base of
about 300 users.  The database was originally a btrieve 6.0 that has been
upgraded through the years.

How is possible to get "Stat 78" within Begin transaction OP 1419?

The following stored proc returns no results. If I remove the UNION ALL
and the second SELECT it does work. What must I do to get the UNION ALL
to work? Thanks.
CREATE PROCEDURE paEmplRelateProc(IN :RR INTEGER)

I'm using the v8 JDBC driver to access a PSQL v8.6 database. I have
set up a test to see whether a connection with an isolation level of
serialable will prevent phantom reads, as specified by the ANSI/ISO
SQL standard.

first my english is bad. i have write a windows application that connect via
pervasive odbc 2.x to a btrieve 6.15 database, when the application is
startet from 5 pc the 6 start from pc 6 don't work, the btrieve tabel or
database is locked? have btrieve 6.15 via odbc a conenction ...

I'm trying to append new text on a field using the concat function.
On the Set statement I use something like this:
Set Field = Concat(Field,'ABC')
And when I check the results 'ABC' wasn't appended to <Field>.  What

Contract Job available for integrating Pervasive SQL 9.5 with Btrieve
6.15 and Excel.  Please contact: jevonjaconi@icscuttingtools.com with
information.  This is located in Green Bay, WI.  Thanks!

does anybody know how to treat empty date columns (shown as 0 in the
pervasive sql.manager) when accessing them via an Ole DB driver?
I always get an exception when accessing it for example in SSIS or in
my C# code, because 0 is a date out of range.