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