Querying the data types of the placeholders and values

If a dynamic statement contains placeholders, you can query the number and SQL data types of the placeholders with DESCRIBE INPUT after you have prepared the statement with PREPARE. To do this, you must specify a descriptor area to which the description of the SQL data types is returned.

You can query the number and data types of the values returned by the prepared statement with DESCRIBE OUTPUT and store the information in a previously requested descriptor area. The number is 0 if the prepared statement is not a SELECT statement or cursor description.

You can read the item descriptors in the descriptor area with GET DESCRIPTOR (see section “Descriptor area”).