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:
- For an individual column, left-click the Type grid
cell and choose Name or Label.
- For all columns, right-click the Type grid column
and choose Set All Name or Set All
Label.
Heading Position
Justification
for column headings. To change the justification:
- For an individual column, left-click the Position
grid cell and choose Left, Center,
or Right.
- For all columns, right-click the Position grid column
and choose Set All Left, Set All
Center, or Set All Right.
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:
- Type the file name extension in the column that
corresponds to the type of LOB (for example, type the extension .doc to
associate a LOB Word document with Microsoft Word).
OR
- If the table contains a reference column used to
identify the LOB data, you can enter the name of the reference column
in the Association column. The first three
characters in the reference column are used as the file name extension
for the LOB data in the corresponding row of the LOB data column.
The reference column must be a character-type column. Click the Association column
to display a drop-down list of the names of character-type columns
in the table, and select the reference column name.
Column Specifications Identified
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.