Filter
Top Products
specified in a dynamic OPEN statement, the cursor must have already been closed.
An example of deallocating the SQL descriptor area with descriptor name DESC1 is shown below.
DESCRIBE statement
The DESCRIBE statement fetches select column list information for the prepared statement prepared by the
PREPARE statement to the SQL descriptor area. This type of statement is called an output DESCRIBE statement.
The following is an example of the DESCRIBE statement that fetches select column list information for the prepared
statement corresponding to SQL statement identifier STM2 to the SQL descriptor area.
If the prepared statement for SQL statement identifier STM2 is the statement shown below, the contents of SQL
descriptor area DESC2 are as follows:
152