Informix FETCH NEXT – PB Docs 2018

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.

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.

See also

Informix FETCH
statements

Informix FETCH FIRST,
FETCH PRIOR, and FETCH LAST