In the Maximum number of rows to fetch field, type the maximum number of rows you want to fetch from the database at any one time. To not have a maximum number of rows, leave this field blank.

Select Enable packeting to be able to fetch rows of the database in packets as requested by the Container Details part. Select Enable packeting only when creating a quick form of a result table.

Select Enable blocked fetches to be able to fetch blocks of data from the databases.

In the Blocked fetch size field, type the number of rows you want to equal a block in the database. If packeting is enabled, type the size for the packet. If the database manager you selected does not support this, the value is ignored. If you leave this field blank, the database manager sets the size of the block. If packeting is enabled, this field should not be left blank.

Use the LOB Definitions list to set fetch options for large objects. You can use the pop-up menu options to set the options for fetching large objects:

Fetches the object itself and stores it in memory

Fetches a handle to the object and enables you to manipulate the object (for example, move it from one column to another) by referring to its handle

Fetches the object itself and stores it in a file.

If the selected database does not contain large objects, this menu item is not available.