User`s guide

7 Functions — Alphabetical List
7-150
Fetch batch size, specified as a scalar denoting the number of rows of data to batch at
a time. Use fetchbatchsize when importing large amounts of data. Retrieving data
in batches reduces overall retrieval time. If fetchbatchsize is not provided, a default
value of 'FetchBatchSize' is used. 'FetchBatchSize' is set using setdbprefs.
Data Types: double
Name-Value Pair Arguments
Specify optional comma-separated pairs of Name,Value arguments. Name is the
argument name and Value is the corresponding value. Name must appear inside single
quotes (' '). You can specify several name and value pair arguments in any order as
Name1,Value1,...,NameN,ValueN.
Example: 'absolutePosition',5
'absolutePosition' — Absolute position offset
scalar
Absolute position offset, specified as a scalar to denote the absolute position offset value.
When you specify an absolute position offset value, fetch imports data starting from the
cursor position equal to this value regardless of the current cursor location. The scalar
can be a positive number to signify fetching data from the start of the data set. Or, the
scalar can be a negative number to signify fetching data from the end of the data set.
This name-value pair argument is only available when you create a scrollable cursor
object using exec. For details, see “Importing Data Using a Scrollable Cursor”.
Data Types: double
'relativePosition' — Relative position offset
scalar
Relative position offset, specified as a scalar to denote the relative position offset value.
When you specify a relative position offset value, fetch adds the current cursor position
value to the relative position offset value. Then, fetch imports data starting from the
resulting value. The scalar can be a positive number to signify importing data after the
current cursor position in the data set. Or, the scalar can be a negative number to signify
importing data before the current cursor position in the data set. This name-value pair
argument is only available when you create a scrollable cursor object using exec. For
details, see “Importing Data Using a Scrollable Cursor”.
Data Types: double