SQL statements are comprised of three types: data definition language (DDL), data manipulation language (DML), and program control statements.
DDL (data definition language) statements let you define and modify your database schema and table and index definitions. Examples of DDL statements include CREATE TABLE, CREATE INDEX, ALTER TABLE, and DROP.
DML (data manipulation language) statements let you query your data, and move data into and out of the database. Examples of DML statements include SELECT, SET, and INSERT.
Program control statements control the flow of program execution. They do not operate directly on your Sybase IQ tables. Examples include IF, CALL, and ROLLBACK.