Overview of OpenSQL
What Is OpenSQL?
SQL (Structured Query Language) is a language that allows you to manipulate and maintain data in a relational database. OpenSQL is a version of SQL that was specifically designed to be compatible across several SQL dialects. OpenSQL allows you to create applications that run on the following servers:
• The Ingres DBMS (for Ingres databases)
• Enterprise Access products (for access to other database management systems)
• Ingres Star (for distributed databases)
• EDBC servers
OpenSQL statements can be used in the following contexts:
• Terminal Monitor
• Embedded OpenSQL programs
• Applications built with Vision (a forms-based application development tool)
• Applications built with OpenROAD (a graphical user interface application development tool)
Use OpenSQL statements in the interactive Terminal Monitor or in embedded OpenSQL programs. OpenSQL statement syntax and results are consistent across supported host programming languages. This guide does not include specific information about host languages. For details, see the Embedded SQL Companion Guide.
Forms statements allow you to write embedded applications that interact with users through Visual Forms Editor forms. For details about forms statements, see the Forms-based Application Development Tools User Guide.