In This Guide
Developing Portable Applications uses the following terms:
• Enterprise Access gateway or gateway is synonymous with Enterprise Access
• OpenSQL is synonymous with Ingres OpenSQL
• Ingres Distributed Option was formerly Ingres/Star
This guide includes the following topics:
• Required components and OpenSQL requirements
• Achieving portability and transparency in relation to Microsoft SQL Server, Oracle, and DB2 UDB features and capabilities
• Application development considerations, including restrictions and limitations that apply when accessing the various databases
• Using the gateway to create and access native DBMS stored procedures as if they were OpenSQL database procedures
• Data type mapping between the gateway SQL and Ingres OpenSQL
• Function mapping between the host DBMS SQL and Ingres OpenSQL