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.