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