Edit masks provide a way to precisely control the formatting
of displayable numbers. The table below summarizes the mappings between
mainframe edit masks and Connect ETL edit masks.
|
Description
|
Mainframe
|
Connect ETL
|
| Significant digit |
T
|
9
|
| Insignificant digit |
I
|
Z
|
| Leading positive/negative sign1
|
SIGN(+,-)
|
+
|
| Leading negative sign (no sign for positive) |
SIGN(,-)
|
-
|
| Trailing positive/negative sign |
SIGN(,,+,-)
|
+
|
| Trailing negative sign (no sign for positive) |
SIGN(,,,-)
|
-
|
| Decimal point |
.
|
V
|
|
1To create a leading sign, place the + or – character at the beginning
of the mask. To create a trailing sign, place the + or – at the end of the
mask. |