Filter
Top Products
[Figure: Procedure for setting dynamic parameter specification values for prepared statement
s]
SQL statements used to manipulate the SQL descriptor area
As shown in "Figure: Procedure for setting dynamic parameter specification values for prepared statements," use SQL
statements to fetch dynamic parameter specification information from the database to the SQL descriptor area and get
dynamic parameter specification information placed in the SQL descriptor area. The SQL statements used to
manipulate the SQL descriptor area and their functions are described below.
DESCRIBE statement
The DESCRIBE statement fetches the dynamic parameter specification information for the prepared statement
prepared by the PREPARE statement in the SQL descriptor area. This type of statement is called an input DESCRIBE
statement. When the descriptor name specified in the DESCRIBE statement is specified in the dynamic OPEN
statement, the cursor must be closed.
An example of the input DESCRIBE statement that fetches dynamic parameter specification information for the
prepared statement corresponding to SQL statement identifier STM1 to the SQL descriptor area is shown below.
171