How Do I...
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:
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.
|
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 ]