User`s guide

Importing Data Using a Scrollable Cursor
6-63
Initial
Scrollable
Cursor
Position
Row Limit Scrollable
Cursor Position
Type
Offset Ending
Scrollable
Cursor Position
fetch Action
records in the
data set.
0 Not specified 'relativePosition'1 0 Retrieves
all rows in
the cursor
starting from
the first row
in the data
set
0 2 'relativePosition'1 2 Retrieves the
first two rows
in the data
set
5 2 'relativePosition'5 11 Retrieves
two rows in
the data set
starting from
five rows from
the initial
position of
five, which is
nine
11 3 'relativePosition'-5 8 Retrieves
three rows
in the cursor
starting from
five rows
before the
eleventh row
in the data
set