Replaces invalid numeric ASCII data with an alternate value.

Syntax

-R value

R

Must be upper case.

value

The replacement value. The default is to replace with 0. Specify one of the following alternate values:

number

Replaces invalid data with the specified number.

NULL

Replaces invalid data with NULL if the target column accepts NULL values. Otherwise, replaces with 0.

UNPRINTABLE

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