Filter
Top Products
[Figure: Procedure for setting dynamic parameter specification values for prepared statement
s]
SQL statements used to manipulate the SQLDA structure
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 SQLDA structure and to get
dynamic parameter specification information from the SQLDA structure. The SQL statements used to manipulate the
SQLDA structure and their functions are explained below.
DESCRIBE statement
The DESCRIBE statement fetches the dynamic parameter specification information for the prepared statement
prepared by the PREPARE statement in the SQLDA structure. This type of statement is called an input DESCRIBE
statement.
An example of an input DESCRIBE statement that fetches dynamic parameter specification information for the
prepared statement corresponding to SQL statement identifier STM1 to the SQLDA structure is shown below.
161