User`s guide

Importing Data Using a Scrollable Cursor
6-61
Initial
Scrollable
Cursor
Position
Row Limit Scrollable
Cursor Position
Type
Offset Ending
Scrollable
Cursor Position
fetch Action
from the end
of the data
set
Before result
set
Not specified 'relativePosition'1 After the
result set
Retrieves
all rows in
the cursor
starting from
the first row
in the data
set
Before result
set
Any 'relativePosition'Any Varies Retrieving
with a
relative
position that
starts before
the result
set causes
behavior to
vary based on
the driver
5 2 'relativePosition'5 10 Retrieves
two rows in
the cursor
starting from
the tenth row
in the data
set
11 3 'relativePosition'-5 6 Retrieves
three rows
in the cursor
starting from
the sixth row
in the data
set