Parts Reference

Fetch Tab for Multi-row Query

Use the Fetch tab to specify the how you want the rows fetched from the database:

Page 1 Settings

Maximum number of rows to fetch
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.

Enable packeting
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.

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

Blocked fetch size
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.

Page 2 Settings

LOB Definitions
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:

LOB Value
Fetches the object itself and stores it in memory

LOB Locator
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

LOB File Reference
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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]