The Columns tab displays information about the table and enables you to choose display options and other criteria, as follows:
Name of each column in the specified table. To rearrange the order in which the columns are displayed in the Table Editor or Point and Shoot Editor, drag the grid row number. You cannot modify column names.
Data type and length for each column. You cannot modify this value.
Check box to identify columns to display in the Table Editor or the Point and Shoot Editor. At least one column per table must be selected for display. By default, all columns are included for display. Clear the check box to exclude a column from the display. This option has no effect on a process that uses the Access Definition.
Null indicator. The value is Yes if the column is defined to accept a NULL value and No, if it is not. You cannot modify this value.
Criteria indicator. This value is Yes if selection criteria are specified for a column and No if no selection criteria are present. You cannot modify this value. (Select the Selection Criteria tab or SQL tab of the Table Specifications dialog to edit or define criteria.)
Type of heading for a column. To set the heading type:
Justification for column headings. To change the justification:
All check boxes in the Extract Data column are selected by default. When you clear a check box, data in the corresponding column is not extracted when the Access Definition is used for an Extract Process.
Select the check box to display LOBs in the Table Editor as normal LOB data. Clear the check box to display LOBs as VARCHAR or VARBIN data. If you clear this check box, a limitation on the amount of data that is retrieved from the LOB applies. The default setting and size limitation is set on the Display tab of Personal Options.
Use this column to associate a LOB column with the application required to view or edit the LOB data, in one of two ways:
OR
The columns icon
in a Table Specifications
grid cell on the Access Definition Editor table
List indicates that columns are rearranged, headings or LOB options
are specified for data displays, or LOB column associations are specified.