SQL statements for dynamic SQL

Dynamic statement

SQL statement	Function
EXECUTE	Execute a prepared statement
EXECUTE IMMEDIATE	Execute a dynamic statement
PREPARE	Prepare a dynamic statement

Table 40: SQL statements for dynamic statements

Descriptor

SQL statement	Function
ALLOCATE DESCRIPTOR	Request SQL descriptor area
DEALLOCATE DESCRIPTOR	Release SQL descriptor area
DESCRIBE	Query data types of input or output values
GET DESCRIPTOR	Read SQL descriptor area
SET DESCRIPTOR	Modify SQL descriptor area

Table 41: SQL statements for descriptors