Dynamic statement

A dynamic statement can either be executed directly once, or it can be prepared. A prepared statement can be executed any number of times.

You cannot use any placeholders in a statement that is executed directly, and it must not return any values.

A prepared statement remains prepared for execution for at least the duration of the current transaction.

The diagram below provides you with an overview of the SQL statements that can be used in dynamic statements:

A descriptor area must be created with ALLOCATE DESCRIPTOR before it is used in DESCRIBE and GET/SET DESCRIPTOR (see section "Descriptor area").