SQL-92 DDL and DML Statements
This section lists Progress SQL-92 DDL and DML Statements. Table E–2 identifies the compliance of each statement as SQL-92, a level of ODBC SQL Grammar, or as a Progress extension.
Table E–2: Compliance of SQL-92 DDL and DML Statements
SQL-92 Statement
|
SQL-92
|
ODBC SQL Grammar
|
Progress Extension
|
Notes
|
ALTER USER
|
–
|
–
|
|
–
|
CALL
|
–
|
Extended
|
–
|
Must enclose in an ODBC escape clause { fn }
|
BEGIN-END DECLARE SECTION
|
|
–
|
–
|
Compliant if C Language types used Embedded SQL-92 only
|
CLOSE
|
|
–
|
–
|
Embedded SQL-92 only
|
COMMIT
|
|
–
|
–
|
–
|
CONNECT
|
|
–
|
USING password
|
–
|
CREATE INDEX
|
–
|
Core
|
AREA area_name
|
–
|
CREATE PROCEDURE
|
–
|
Core
|
|
–
|
CREATE SYNONYM
|
–
|
–
|
|
–
|
CREATE TABLE
|
|
Minimum
|
AREA AS query_expression
|
–
|
CREATE TRIGGER
|
–
|
Core
|
|
–
|
CREATE USER
|
–
|
–
|
|
–
|
CREATE VIEW
|
|
Core
|
–
|
–
|
DECLARE CURSOR
|
|
–
|
prepared_stmt_name
|
Embedded SQL-92 only
|
DELETE
|
|
Extended
|
–
|
–
|
DESCRIBE
|
|
–
|
–
|
Embedded SQL-92 only
|
DISCONNECT
|
|
–
|
–
|
–
|
DROP INDEX
|
–
|
Core
|
–
|
–
|
DROP PROCEDURE
|
–
|
Core
|
|
–
|
DROP SYNONYM
|
–
|
–
|
|
–
|
DROP TABLE
|
–
|
Minimum
|
|
–
|
DROP TRIGGER
|
–
|
–
|
|
–
|
DROP USER
|
–
|
–
|
|
–
|
DROP VIEW
|
–
|
Core
|
|
–
|
EXEC SQL
|
|
–
|
–
|
Embedded SQL-92 only
|
EXECUTE
|
|
–
|
–
|
Embedded SQL-92 only
|
EXECUTE IMMEDIATE
|
|
–
|
–
|
Embedded SQL-92 only
|
FETCH
|
|
–
|
USING DESCRIPTOR
|
Embedded SQL-92 only
|
GET DIAGNOSTICS
|
–
|
–
|
|
Embedded SQL-92 only
|
GRANT
|
|
Core
|
INDEX RESOURCE DBA
|
–
|
INSERT
|
|
Core
|
–
|
–
|
LOCK TABLE
|
–
|
–
|
|
–
|
OPEN
|
|
–
|
USING DESCRIPTOR
|
Embedded SQL-92 only
|
PREPARE
|
|
–
|
–
|
Embedded SQL-92 only
|
REVOKE
|
|
Core
|
INDEX RESOURCE DBA
|
–
|
ROLLBACK
|
|
–
|
–
|
–
|
SELECT
|
|
Extended
|
FOR UPDATE
|
–
|
SET CONNECTION
|
|
–
|
–
|
–
|
SET SCHEMA
|
|
–
|
–
|
–
|
SET TRANSACTION ISOLATION LEVEL
|
–
|
–
|
|
–
|
UPDATE
|
|
Extended
|
assignments of form: ( column, column ) = ( expr, expr )
|
–
|
UPDATE STATISTICS
|
–
|
–
|
|
–
|
WHENEVER
|
|
–
|
SQLWARNING STOP ACTION
|
Embedded SQL-92 only
|