Filter
Top Products
statements that can use the SQL structure, see the examples in "Figure: Procedure for fetching execution results for a
prepared statement."
Example:
This is an example of a dynamic single row SELECT statement entered from a terminal.
7.2.2 Preparing SQL statements and manipulating the SQL descriptor area
When data is fetched from a database using dynamic SQL, specify the target that will receive the execution results.
For the specified target to be able to receive the execution results, the select column list information must match the
attributes of the specified target. Matching is accomplished by fetching the select column list information from the
database to the SQLDA structure, then modifying the attributes. The SQL descriptor area is positioned as shown in
the figure below.
146