Filter
Top Products
Using the dynamic FETCH statement to fetch execution results
Specify USING arguments in the dynamic FETCH statement to fetch execution results.
Example 4:
In this example, values of PRODUCT and STOCKQTY with ITMNO greater than "200" are fetched
from the STOCK table. The data types of ITMNO and STOCKQTY and those of the two arguments in
which the results are fetched must be comparable.
Using the dynamic OPEN statement to set the values of dynamic parameter
specifications and the dynamic FETCH statement to fetch execution results
Specify USING arguments in the dynamic OPEN statement and the dynamic FETCH statement to set the values of
dynamic parameter specifications and fetch execution results.
Example 5:
In this example, values for PRODUCT with ITMNO between "140" and "240" inclusive are fetched from
the STOCK table. The data types of ITMNO, the two arguments in which the values are set and the
argument to which the result is fetched must be comparable.
186