ODBC
FETCH NEXT
In the singleton SELECT, you specify variables to hold values for
the columns within the selected row. The syntax of the FETCH statement is
similar to the singleton SELECT statement syntax. Values are returned INTO
a specified list of variables.
Example
This example continues the previous example by retrieving some
data:
|
1 2 |
// Go get the first row from the result set. FETCH emp_curs INTO :emp_id_var, :emp_name_var; |
If at least one row is retrieved, this FETCH places the values of
the emp_id and emp_name columns from the first row in the result set into
the PowerScript variables emp_id_var and emp_name_var. FETCH statements
typically occur in a loop that processes several rows from a result set
(one row at a time), but this is not the only way they are used.
What happens when the result set is exhausted?
FETCH returns +100 (not found) in the SQLCode property within the
referenced transaction object. This is an informational return code; -1
in SQLCode indicates an error.
See also