User`s guide

5 Using Visual Query Builder
5-18
Preference Acceptable Values Description
Cursor
Fetch
Fetch In
Batches and
Batch Size
Specifies if fetch retrieves data in batches with a user-defined
Batch Size. The default Batch Size is 1,000. For details, see
“Preference Settings for Large Data Import” on page 5-19.
This setting does not apply to Database Explorer. If you are
using Database Explorer, the import batch size is specified using
Preferences on the Database Explorer Toolstrip.
3
Click OK. For details about Preferences, see setdbprefs.