Corporation Video Gaming Accessories User Manual

Metadata for the IMS/DB Data Source
A-4 Oracle Application Server Adapters for IMS/DB User's Guide
Figure A–2 The Columns tab
Column Definition Section
The top section of this tab lets you define the columns in the source data. You can click
in any row (which represents a column in the data base table) to edit the information.
The following table describes this section.
Table A–2 Metadata Column Tab Definitions
Field name Description
Name The name of the column
Data type The data type of the column. Selecting this field displays a
drop-down box listing the possible data types.
Size The size of the column
Scale The information entered in this field depends on the data type:
For decimal data types, this is the number of digits to the right of
the decimal place. This number must not be greater than the
number of digits. The default value is 0.
For scaled data types, this is the total number of digits. The
number must be negative.
Dimension The maximum number of occurrences of a group of columns
that make up an array.
The (+) to the left of a column indicates a group field. This type
of field will have a Dimension value. Click (+) to display the
group members.
Offset An absolute offset for the field in a record.