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]

number

Replaces the invalid field with a specified value.

NULL

Replaces the field with NULL whenever possible; otherwise, replaces the field with zero.

UNPRINTABLE

When mapping data, rejects invalid numeric fields.
When formatting invalid data in ASCII or SQL output, outputs a zero instead.