On Nov 2, 9:47*am, David Brooks <dbro... (AT) visionsystemssoftware (DOT) com>
wrote:
Both Ingres/Star and the Microsoft SQL Server Gateway understand
OpenSQL (see the OpenSQL guide, either the PDF or online version at
http://docs.actian.com/ingres/10.0/sql-reference-guide/ ). The problem
with using "the SQL standard" is that sometimes that isn't enough,
e.g. consider the syntax used for temporary tables in mssql (they are
prefixed with a "#").

If you use OpenSQL, the same application should work against Ingres
and Microsoft SQL Server. However it is possible to use Microsoft SQL
Server specific SQL against the gateway, which of course won't work
with Ingres and vice-versa. I.e. applications are more portable if
they are written with portability in mind. It is possible to modify an
existing application to use OpenSQL but it is almost easier to do it
at the start of new project.

The Enterprise Access (aka gateway) Developing Portable Applications
(DPA) Guide (http://docs.actian.com/enterprise-access/2.7) and the
Ingres OpenSQL manual are good starting resources for this. I
recommend pulling the whole PDF set down as there is a "Bookshelf"
that allows searching across all the guides.

Chris