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