Types of Executable Statements

The ESQL executable statements can be categorized into the following types:

DML statements

These statements perform data manipulation operations that can be used to manipulate the database. The DML operations are SELECT, INSERT, UPDATE and DELETE. The DML statements are the most frequently used statements in ESQL programs.

DDL statements

These statements perform data definitions on a given database. The DDL statements include statements for creating tables/views, dropping tables/views etc.

DCL statements

These statements are used basically for maintaining the security of a database.

Transaction management statements

The transaction statements are used for transaction management. The statements include COMMIT WORK and ROLLBACK WORK.