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.
- 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.