Valid for
Extract, Replicat
Description
Use REPLACEBADCHAR
to substitute a specified value whenever an unprintable character is encountered during mapping or ASCII formatting.
REPLACEBADCHAR
applies globally. If data is ASCII formatted and transported to a platform other than NonStop, you must specify the –r parameter in the Collector startup command.
Default
No replacement when mapping data; Replace with spaces when formatting ASCII data
Syntax
REPLACEBADCHAR char
[, SPACE]
[, NULL]
[, NONE]
[, UNPRINTABLE]
char
A character value with which to replace unprintable character bytes.
SPACE
Replaces unprintable character values with spaces.
NULL
Replaces the field with NULL
whenever possible, otherwise, replaces the field with spaces.
NONE
Suppresses transformation of double-byte character set values to default characters when the incoming data is converted to ASCII format. This is useful when delivering double-byte character sets.
UNPRINTABLE
When mapping data, rejects character fields or columns with unprintable data.
When formatting data in ASCII or SQL output, outputs the word "UNPRINTABLE
" or a question mark output for the field or column.