source_replace_single_byte_charset_characters

This system parameter replaces matching characters in all columns of all tables. It is similar to %REPLACE, but applies to all in-scope source tables.

Applies to
Source datastores
Values
Set this parameter to a string value with one or more replacement specifications. Each specification includes a single-byte IANA character set name, an ampersand (&), then a comma-separated list of mappings. Each mapping specifies the original single‑byte hex code point and its corresponding replacement hex code point, separated by a colon (:). This format allows you to indicate which byte values in a given character set must be replaced with alternative values, ensuring proper handling of character substitutions during processing. Separate each replacement specification from the next with a semicolon.
Syntax
/replacementSpecification/[;/replacementSpecification/...]
/replacementSpecification/ ::= IANACharacterSetName&/replacementCharSpecSet/
/replacementCharSpecSet/ ::= /replacementCharSpec/[,/replacementCharSpec/...]
/replacementCharSpec/ ::= origHexCodePoint:replacementHexCodePoint
For this system parameter to function correctly, these conditions must be met in order:
  1. Specify one or more replacement specifications, separated by a semi-colon.
  2. Specify one or more replacement character specifications, separated by a comma.
  3. Trim and ignore any white space in the specification, except inside a replacementCharSpec, and ignore spaces between hex code point digits or between the hex code points and the separating colon.
  4. Specify a semi-colon only at the end of a character set replacement specification if there is a subsequent character set replacement specification. CDC Replication ignores any trailing semi-colon.
  5. Specify a comma only at the end of a replacement character specification if there is a subsequent replacement character specification. CDC Replication ignores any trailing comma.
  6. Provide the IANACharacterSetName as the exact IANA encoding name for that character set. CDC Replication ignores case while validating that the character set name exists and is a single‑byte character set.
  7. Specify origHexCodePoint and replacementHexCodePoint as exactly 2 hex characters long. The origHexCodePoint is the hex code for a character to replace in the specified character set and replacementHexCodePoint is the hex code for the substitute character in the specified character set.
For example, 
IBM037&00:40,0D:40,15:40;IBM1047&00:40,0D:40,15:40
For this example, CDC Replication works as follows:
  • For the single‑byte EBCDIC character set IBM037:
    • Replace the NULL character with a space (blank).
    • Replace CR (carriage return) with a space.
    • Replace LF (line feed) with a space.
  • For the single‑byte EBCDIC character set IBM1047:
    • Replace the NULL character with a space (blank).
    • Replace CR with a space.
    • Replace LF with a space.
Default Setting
null