SQL statement descriptions

• ALLOCATE DESCRIPTOR - Request SQL descriptor area
• ALTER SPACE - Modify space parameters
• ALTER STOGROUP - Modify storage group
• ALTER TABLE - Modify base table
• CALL - Execute procedure
• CASE - Execute SQL statements conditionally
• CLOSE - Close cursor
• COMMIT WORK - Terminate transaction
• COMPOUND - Execute SQL statements in a common context
• CREATE FUNCTION - Create User Defined Function (UDF)
• CREATE INDEX - Create index
• CREATE PROCEDURE - Create procedure
• CREATE SCHEMA - Create schema
• CREATE SPACE - Create space
• CREATE STOGROUP - Create storage group
• CREATE SYSTEM_USER - Create system entry
• CREATE TABLE - Create base table
• CREATE USER - Create authorization identifier
• CREATE VIEW - Create view
• DEALLOCATE DESCRIPTOR - Release SQL descriptor area
• DECLARE CURSOR - Declare cursor
• DELETE - Delete rows
• DESCRIBE - Query data type of input and output values
• DROP FUNCTION - Delete User Defined Function (UDF)
• DROP INDEX - Delete index
• DROP PROCEDURE - Delete procedure
• DROP SCHEMA - Delete schema
• DROP SPACE - Delete space
• DROP STOGROUP - Delete storage group
• DROP SYSTEM_USER - Delete system entry
• DROP TABLE - Delete base table
• DROP USER - Delete authorization identifier
• DROP VIEW - Delete view
• EXECUTE - Execute prepared statement
• EXECUTE IMMEDIATE - Execute dynamic statement
• FETCH - Position cursor and read row
• FOR - Execute SQL statements in a loop
• GET DESCRIPTOR - Read SQL descriptor area
• GET DIAGNOSTICS - Output diagnostic information
• GRANT - Grant privileges
• IF - Execute SQL statements conditionally
• INCLUDE - Insert program text into ESQL programs
• INSERT - Insert rows in table
• ITERATE - Switch to the next loop pass
• LEAVE - Terminate a loop or COMPOUND statement
• LOOP - Execute SQL statements in a loop
• MERGE - Insert rows in a table or update column values
• OPEN - Open cursor
• PERMIT - Specify user identification for SESAM/SQL V1.x
• PREPARE - Prepare dynamic statement
• REORG STATISTICS - Regenerate global statistics
• REPEAT - Execute SQL statements in a loop
• RESIGNAL - Report exception in local exception routine
• RESTORE - Restore cursor
• RETURN - Supply the return value of a User Defined Function (UDF)
• REVOKE - Revoke privileges
• ROLLBACK WORK - Roll back transaction
• SELECT - Read individual rows
• SET - Assign value
• SET CATALOG - Set default database name
• SET DESCRIPTOR - Update SQL descriptor area
• SET SCHEMA - Specify default schema name
• SET SESSION AUTHORIZATION - Set authorization identifier
• SET TRANSACTION - Define transaction attributes
• SIGNAL - Report exception in routine
• STORE - Save cursor position
• UPDATE - Update column values
• WHENEVER - Define error handling
• WHILE - Execute SQL statements in a loop