Pervasive SQL syntax

[stpaul]

I am a SQL Server programmer who now needs to be able to do stored procedures in Pervasive SQL. Although much of the syntax in the data manager is similar to that in T-SQL (SQL Servers version of SQL), there are some differences. I was wondering if anyone knows a good resource of the SQL syntax.

TIA
Paull

 

[jemahoney]

Snytax is very straightforward. Here is one written for Scalable SQL, a slightly older version of Pervasive.sql
Create Proc K_test @parm1 as Select * from Batch where Status = 'K' and batch.editscrnnbr = @parm1;

 

[Pervasivite]

Yes you should get a copy of the Pervasive.SQL 2000 SDK which contains all the docs and reference manuals on the SQL used by Pervasive.SQL 2000. Much if it is also contained in Pervasive.SQL 2000i which is P2K with SP3 applied though it does have quite a bit of new functionality. You can download and use the SDK free for 30 days and even after 30 days it retains local workstation access and all the docs and samples. Also all the documentation for Pervasive.SQL 7 (which used ScalableSQL syntax) and Pervasive.SQL 2000i (which uses standard ODBC syntax for everything where that is defined by the ODBC spec) is freely downloadable from

http://www.pervasive.com

Pervasivite.