Filter
Top Products
7.2.2.2 Preparing and executing a dynamic single row SELECT statement (for
SQL descriptor area)
To fetch data from one row, prepare and execute a dynamic single row SELECT statement. To execute a dynamic
single row SELECT statement, use an EXECUTE statement in which the USING clause is specified. An example of a
dynamic single row SELECT statement using the SQL descriptor area is shown below. For information about the SQL
statements that can use the SQL descriptor area, 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.
158