SQL statements for dynamic SQL

SQL statement	Function
PREPARE	Checks a dynamically compilable SQL statement or cursor description and prepares it for execution
EXECUTE	Executes a statement already prepared with PREPARE
EXECUTE IMMEDIATE	Checks a dynamically compilable statement and executes it
ALLOCATE DESCRIPTOR	Creates an SQL descriptor area
GET DESCRIPTOR	Reads entries from an SQL descriptor area
SET DESCRIPTOR	Updates an SQL descriptor area
DEALLOCATE DESCRIPTOR	Releases an SQL descriptor area
DESCRIBE	Provides information on derived columns or input values in a dynamically compiled statement or cursor description

Table 26: SQL statements for dynamic SQL