Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SQL-92 DDL and DML statements

> Table 51 lists OpenEdge SQL DDL and DML Statements. A check mark identifies the compliance of each statement as SQL-92, a level of ODBC SQL Grammar, or as a Progress extension.

> Table 51: Compliance of SQL-92 DDL and DML statements
> OpenEdge SQL statement | SQL-92 | ODBC SQL grammar | Progress extension | Notes
> --- | --- | --- | --- | ---
> `ALTER USER` | – | – |  | –
> `CALL` | – | Extended | – | Must enclose in an ODBC escape clause { fn }.
> `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 | – | –
> `DELETE` |  | Extended | – | –
> `DISCONNECT` |  | – | – | –
> `DROP INDEX` | – | Core | – | –
> `DROP PROCEDURE` | – | Core |  | –
> `DROP SYNONYM` | – | – |  | –
> `DROP TABLE` | – | Minimum |  | –
> `DROP TRIGGER` | – | – |  | –
> `DROP USER` | – | – |  | –
> `DROP VIEW` | – | Core |  | –
> `GRANT` |  | Core | `INDEX RESOURCE DBA` | –
> `INSERT` |  | Core | – | –
> `LOCK TABLE` | – | – |  | –
> `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` | – | – |  | –

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