User`s guide

6 Using Database Toolbox Functions
6-60
• The fetch Action column describes the rows of data to retrieve based on the specified
input arguments.
For example, this code demonstrates the syntax for calling fetch shown in the second
row of either table.
curs = fetch(curs,2,'absolutePosition',1);
Native ODBC
Initial
Scrollable
Cursor
Position
Row Limit Scrollable
Cursor Position
Type
Offset Ending
Scrollable
Cursor Position
fetch Action
Any Not specified 'absolutePosition'1 After the
result set
Retrieves
all rows in
the cursor
starting from
the first row
in the data
set
Any 2 'absolutePosition'1 1 Retrieves
two rows in
the cursor
starting from
the first row
in the data
set
Any 2 'absolutePosition'5 5 Retrieves
two rows in
the cursor
starting from
the fifth row
in the data
set
Any 3 'absolutePosition'-5 11 Retrieves
three rows
in the cursor
starting from
the fifth row