The -nz switch maps numeric data (including blank fields) exactly as it appears on the map. Earlier versions of ECRTP padded numeric values with leading zeros are based on field length.
Inbound maps.
4.2
The syntax for this switch is:
-nz
Adding literal mapping options in Windows
Open the Run Inbound Map window.
Click the Option 2 tab.
In the Zero Handling Options group, select No Zero Fill on Null or Non-Null Numbers.
Different switch options provide different results. These examples assume a numeric field size of 5, and the following input values: '123', '0', ' ' (empty).
Default (no switch) option, the output
is: '123'
, '0'
and '0'
.
-z switch option, the output
is: '00123'
, '00000'
and '
'
(empty).
-nz switch option, the output
is: '123
', '0'
and '
'
(empty).