PowerCenter
- PowerCenter 10.5.1
- All Products
Attribute
| Description
|
---|---|
POffs
| Physical offset. Location of the field in the file. The first byte in the file is zero.
|
Plen
| Physical length. Number of bytes in the field.
|
Column Name
| Name of the source field.
|
Level
| 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.
|
Occurs
| The number of instances of a column or group of columns in the source row.
|
Datatype
| The transformation datatype can be String, Nstring, or Number.
|
Prec
| Precision. Length of the column.
|
Scale
| Number of decimal positions for a numeric column.
|
Picture
| 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.
|
Usage
| 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.
|
Key Type
| Type of key constraint to apply to the field for a VSAM file. Choose one of the following key types:
|
Signed (S)
| 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.
|
Redefines
| Indicates that the column REDEFINES another column.
|
Business Name
| Descriptive name that you give to a column.
|