Defining column specifications

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:

  1. 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.
  2. Select the Tables tab.
  3. Select the table for the selection criteria.
  4. Click Add Selection Criteria. The Table Specification window opens.
  5. Select the Columns tab.
  6. In the Extract Data column, select columns from which to extract data.
  7. 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.
  8. 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.
  9. Click OK.
  10. Save the access definition.


Feedback