Parts Reference
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 ]