Kbase P67908: What is Progress SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/13/2010 |
|
Status: Verified
GOAL:
What is Progress SQL-92?
GOAL:
What is the SQL-92 engine which was introduced in Progress version 9.1?
GOAL:
What are the details of the SQL-92 engine?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
OpenEdge Category: SQL
FIX:
The Progress version 9.1 database offers flexibility in developing software solutions by providing both a high performance interface for Progress 4GL and an open, standards-based interface for SQL-92. The Progress SQL-92 engine is consistent with the requirements of the SQL standard (ANSI SQL-92 Entry-Level+).
More detailed information can be found in the "SQL-92 Guide and Reference" documentation. The white paper called "Progress SQL92 Server: Installation, Environment, and Administration" also contains very useful information. For information on how to migrate from SQL-89, please refer to the "Migrating to v9 SQL-92: ODBC, JDBC and ESQL/C" document.
Both white papers are available on the Progress Communities website; enter the title into the search bar to access the paper. To access Progress Communities, click the "Developers Network" or "Communities" link at the top of any page of the Progress website at http://www.progress.com.