Try OpenEdge Now
skip to main content
SQL Reference
ESQL Reference : Embedded SQL : Compliance with industry standards
 

Compliance with industry standards

The following table provides details on SQL DDL and DML compliance with industry standards. A check mark indicates compliance.
SQL
ODBC SQLgrammar
Progress extension
Notes
BEGIN-END DECLARE SECTION
a
Compliant if C language types usedEmbedded SQL only
CLOSE
a
Embedded SQL only
DECLARE CURSOR
a
prepared_stmt_name
Embedded SQL only
DESCRIBE
a
Embedded SQL only
EXEC SQL
a
Embedded SQL only
EXECUTE
a
Embedded SQL only
EXECUTE IMMEDIATE
a
Embedded SQL only
FETCH
a
USING DESCRIPTOR
Embedded SQL only
GET DIAGNOSTICS
a
Embedded SQL only
OPEN
a
USING DESCRIPTOR
Embedded SQL only
PREPARE
a
Embedded SQL only
ROLLBACK
a
SELECT
a
Extended
FOR UPDATE
WHENEVER
a
SQLWARNING
STOP ACTION
Embedded SQL only