Oracle Application Software 10.1.3.4 Manuel d'utilisateur télécharger pdf (Page 122)

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.

1 2 ... 117 118 119 120 121 122 123 124 125 126 127 ... 169 170

Pas de commentaire

Oracle Application Software 10.1.3.4 Manuel d'utilisateur Page 122