FETCH

The FETCH statement positions a cursor on a row of the result table. It can return zero, one, or multiple rows, and it assigns the values of the rows returned to variables.

For more information, see FETCH in the SQL Reference topic in the Information CenterLink to Information center.