6.125 REPLACEBADNUM

Valid For

Replicat

Description

Use the REPLACEBADNUM parameter to specify a substitution value for invalid numeric data encountered when mapping number columns. REPLACEBADNUM applies globally.

Default

Replace invalid numbers with NULL.

Syntax

REPLACEBADNUM {number | NULL | UNPRINTABLE}

number

Replace with the specified number.

NULL

Replace with NULL if the target column accepts NULL values; otherwise replace with zero.

UNPRINTABLE

Reject any column with unprintable data. The process stops and reports the bad value.

Examples

Example 1   

REPLACEBADNUM 1

Example 2   

REPLACEBADNUM NULL