SELECT Multi-Row

Creates a SELECT statement that retrieves multiple rows of data and generates positioned EASEL action routines when you compile the SAM.

SELECT Single-Row

Creates a SELECT statement that retrieves a single row of data.

UPDATE Searched

Creates an UPDATE statement that updates one or more rows of data.

UPDATE Positioned

Creates an UPDATE statement that uses the WHERE CURRENT OF syntax to update a single row of data pointed to by the current position of a cursor.

DELETE Searched

Creates a DELETE statement that deletes one or more rows of data.

DELETE Positioned

Creates a DELETE statement that uses the WHERE CURRENT OF syntax to delete the row pointed to by the current position of a cursor.

INSERT

Creates an INSERT statement.

Other

Creates any type of SQL statement other than SELECT, UPDATE, DELETE, or INSERT.