REPLACEBADCHAR
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.
-