Columns Tab

The Columns tab displays information about the table and enables you to choose display options and other criteria, as follows:

Column

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

Data type and length for each column. You cannot modify this value.

Display

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 using the Access Definition.

Nullable

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

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

Heading Type

Type of heading for a column. To set the heading type:

Heading Position

Justification for column headings. To change the justification:

Extract Data

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.

Note: Only columns with CLOB or BLOB data types are permitted to be excluded. Columns are NOT excluded when the Access Definition is used in an Archive Process.

Native LOB Mode

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 retrieved from the LOB applies. The default setting and size limitation is set on the Display tab of Personal Options.

Association

Use this column to associate a LOB column with the application required to view or edit the LOB data, in one of two ways:

Column Specifications Identified

The columns icon 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.