User`s guide

Importing Data Using the fetch Function

6-51

Difference Cursor Object Database Connection Object

Fetching in batches You can fetch data

in batches by using

setdbprefs.

This syntax always fetches

data in batches despite

the value of the database

preference property

'FetchInBatches'. This

syntax uses the value of the

database preference property

'FetchBatchSize' as the

default number of records to

fetch in a single batch.

Batch size You can change the batch

size by using setdbprefs.

You can change the batch

size immediately by

using the batch size input

argument.

Database Consideration

The order of records in your database does not remain constant. Sort data using the SQL

ORDER BY command in your sqlquery statement.