Informix FETCH NEXT
In the singleton SELECT, you specify variables to hold the
values for the columns within the selected row. The FETCH statement
syntax is similar to the syntax of the singleton SELECT. Values
are returned INTO a specified list of variables.
// Go get the first row from the result set
FETCH emp_curs INTO :emp_id_var, :emp_name_var;
If at least one row can be 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. Executing another FETCH statement
will place the variables from the next row into specified variables.
FETCH statements typically occur in a loop that processes
several rows from a result set (one row at a time); fetch the row,
process the variables, and then fetch the next row.
What happens when the result set is exhausted?
When a result set has been 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.