Filter
Top Products
information must match the host variable attributes. Matching is accomplished by fetching dynamic parameter
specification information from the database to the SQL descriptor area, modifying the attributes, and then specifying
the value. The following figure shows the position of the SQL descriptor area.
The SQL descriptor area either consists of only one identifier (COUNT) or consists of one identifier (COUNT) and one
or more item descriptor areas (elements of the SQL descriptor area). The data type is exact numeric with binary
precision. In the following figure, n indicates the number of dynamic parameter specifications in the SQL descriptor
area.
For more information about the SQL descriptor area, see "7.2.2 Preparing SQL statements and manipulating the SQL
descriptor area."
Procedure for setting dynamic parameter specification values
"Figure: Procedure for setting dynamic parameter specification values for prepared statements" shows how to use the
USING descriptor to set dynamic parameter specification values.
170