Progress
Embedded SQL-92
Guide and Reference
Types of Executable Statements
There are four categories of ESQL executable statements:
- DML statements
These statements perform data manipulation operations that can be used to manipulate the data in the database. The DML operations are SELECT, INSERT, UPDATE and DELETE. DML statements are the most frequently used statements in ESQL programs.
- DDL statements
Use these statements to perform data definitions for a given database. DDL includes statements to CREATE tables or views and to DROP tables or views. Progress SQL-92 provides extensions to the Data Definition Language, including ALTER USER, CREATE SYNONYM, CREATE USER, DROP SYNONYM, and DROP USER.
- DCL statements
Use these statements to maintain the security of the database. The statements are GRANT and REVOKE.
- Transaction management statements
Use these statements to manage the start and end of transactions. The statements are COMMIT and ROLLBACK.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |