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
|