- PowerCenter 10.4.0
- All Products
Physical offset. Location of the field in the file. The first byte in the file is zero.
Physical length. Number of bytes in the field.
Name of the source field.
Provides column group hierarchy. The higher the level number, the lower the data is in the hierarchy. Columns in the same group occur beneath a column with a lower level number. When each column is the same level, the transformation contains no column groups.
The number of instances of a column or group of columns in the source row.
The transformation datatype can be String, Nstring, or Number.
Precision. Length of the column.
Number of decimal positions for a numeric column.
How the data is stored or displayed in the source. Picture 99V99 defines a numeric field with two implied decimals. Picture X(10) indicates ten characters.
COBOL data storage format such as COMP, BINARY, and COMP-3. When the Usage is DISPLAY, the Picture clause defines how the source data is formatted when you view it.
Type of key constraint to apply to the field for a VSAM file. Choose one of the following key types:
Indicates whether numeric values are signed.
Trailing Sign (T)
Indicates that the sign (+ or -) exists in the last digit of the field. If not enabled, the sign appears as the first character in the field.
Included Sign (I)
Indicates whether the sign is included in any value appearing in the field.
Real Decimal Point (R)
Indicates whether the decimal point is a period (.) or the decimal point is represented by the V character in a numeric field.
Indicates that the column REDEFINES another column.
Descriptive name that you give to a column.