Use the Table Specification window
to define column specifications. You can specify columns from which
to extract data and LOB display options
To define column specifications:
- Expand a folder in the Directory Explorer that contains
the access definition, expand the Access Definitions node,
and double-click the access definition. The Access
Definition Editor opens.
- Select the Tables tab.
- Select the table for the selection criteria.
- Click Add Selection Criteria. The Table Specification window opens.
- Select the Columns tab.
- In the Extract Data column, select
columns from which to extract data.
- In the Native LOB Mode column, select
LOB columns to display as normal LOB data when using the Edit or Browse
utilities. Clear the check box to display LOBs as VARCHAR or VARBIN data.
For Oracle only, select LOB columns to extract (via Archive, Extract or in Compare) as normal LOB data.
For better performance clear the check box to extract data that is <=4K as VARCHAR or VARBINARY data.
If any data in the column is >4K, the process will terminate and an error will be returned.
For DB2 only, select LOB columns to extract (via Archive, Extract or in Compare) as normal LOB data.
For better performance, clear the check box when all data in the column is <=32K.
- In the Association column, enter
a file extension (such as .jpg) that is associated with an application
that is used to view or edit LOB data.
- Click OK.
- Save the access definition.