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