Progress
SQL-92
Guide and Reference


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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095