How Do I...

Setting a fetch policy

Create a package specification No tip for this topic No example for this topic Setting an update policy

Use the Fetch pages of the Multi-row Query Settings window to set the fetch policy of a query. This settings page has the following options:

Fetch Options - Page 1 of 2

Page 1 has the following fetch options:

Maximum number of rows to fetch
The number of rows to be returned by the query.

Enable packeting
Enables the container details part (the quick form for multi-row query result tables) to request the result table rows as the application needs them. This option can speed the display of result table data by loading into memory only those rows that can be displayed in the container details part (plus a number of buffered rows to make scrolling through the result table more smooth).

Enable blocked fetches
Enables you to set a blocked fetch size.

Blocked fetch size
The number of rows to fetch in a block. If packeting is enabled, blocked fetch size also determines the size of a packet.

If you leave this field blank, then the database manager automatically determines the block size. If packeting is enabled, this field should not be left blank.

Note:If you are using ODBC, there may be specific drivers that do not support blocked fetch size.

Fetch Options - Page 2 of 2

Page 2 has the following fetch options for IBM DB2/2 V2.1 and above only:

Column Name
Lists the columns in the table that contain large objects.

LOB Type
Enables you to determine how the object is to be fetched. This field has a pop-up menu with the following options:

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


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