Kbase P132262: SQL: What is the OpenEdge SQL level of compliance with Industry Standards?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/11/2008 |
|
Status: Unverified
GOAL:
SQL: What is the OpenEdge SQL level of compliance with Industry Standards?
GOAL:
Where is the OpenEdge SQL level of compliance with the SQL-92 Standard documented?
GOAL:
Where is the OpenEdge SQL level of compliance with the ODBC Standard documented?
GOAL:
What OpenEdge SQL 'Scalar functions' and what 'SQL-92 DDL and DML statements' are Progress extension to the Industry Standards?
GOAL:
How to interpret the 'Scalar functions' and the 'SQL-92 DDL and DML statements' tables in the 'Compliance with Industry Standards' chapter of the 'OpenEdge Data Management: SQL Reference' manual?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
The chapter entitled "Compliance with Industry Standards" of the "OpenEdge Data Management: SQL Reference" manual identifies which of the OpenEdge Scalar functions, DDL and DML statements are SQL-92 standard compatible, ODBC standard compatible or a Progress extension:
A. In the table that lists the SQL scalar functions supported in OpenEdge SQL:
1. A check mark in the SQL-92 column next to a function indicates that the OpenEdge version of that function complies with the SQL-92 standard. That is it uses the same syntax and has the same functionality as defined in the SQL-92 standard.
2. A check mark in the ODBC column next to a function indicates that the OpenEdge version of that function complies with the ODBC standard. That is it uses the same syntax and has the same functionality as defined in the ODBC standard.
3. A check mark in the Progress extension column next to a function indicates that the OpenEdge version of that function is a purely Progress extension. That is it is a Progress proprietary statement that not included in either the SQL-92 or the ODBC standards.
4. A remark in the notes column next to a function specifies any special syntax that needs to be used with that function.
B. In the table that lists the SQL DDL and DML Statements. supported in OpenEdge SQL:
1. A check mark in the SQL-92 column next to a statement indicates that the OpenEdge version of that statement complies with the SQL-92 standard. That is it uses the same syntax and has the same functionality as defined in the SQL-92 standard.
2. A check mark in the ODBC column next to a statement indicates that the OpenEdge version of that statement complies with the ODBC standard. That is it uses the same syntax and has the same functionality as defined in the ODBC standard.
3. A check mark in the Progress extension column next to a statement indicates that the OpenEdge version of that statement is a purely Progress extension. That is it is a Progress proprietary statement that not included in either the SQL-92 or the ODBC standards.
4. A remark in the notes column next to a statement specifies any special syntax that needs to be used with that statement.