2.185 REPLACEBADNUM
Valid for
Extract, Replicat
Description
Use REPLACEBADNUM
to specify a value to substitute whenever a numeric field that contains non-numeric data is encountered during mapping or ASCII formatting. This is most often seen in Enscribe data when, for example, a PIC 9(4) field contains spaces.
REPLACEBADNUM
applies globally. If data is ASCII formatted and transported to a platform other than NonStop, you need to specify the –R
parameter in the Collector startup command.
Default
Replace invalid numbers with zero when both mapping and formatting data
Syntax
REPLACEBADNUM number
[, NULL] [, UNPRINTABLE]