Filter
Top Products
single-row SELECT statement, use the EXECUTE statement with the USING clause specified.
An example of using the SQLDA structure to specify a dynamic single-row SELECT statement with the dynamic
parameter specification is shown below. For information about the SQL statements used to manipulate the SQL
structure, see "Figure: Procedure for setting dynamic parameter specification values for prepared statements."
Example:
This is an example of a dynamic single-row SELECT statement entered from a terminal. Data is
searched using the value of the dynamic parameter specification entered from the terminal as the
search condition, and the value is displayed.
7.3.2 Using the SQL descriptor area
To dynamically modify only the SQL statement condition and manipulate data, specify the dynamic parameter. Store
values to be input in the host variable. When the host variable value is set, the dynamic parameter specification
169