TRAILCHARSETASCII

Valid For

Extract for DB2 on z/OS

Description

Use TRAILCHARSETASCII to cause character data to be written to the trail file in the local ASCII code page of the DB2 subsystem from which data is to be captured.

  • Specification of this parameter on a single-byte DB2 z/OS subsystem causes character data from non-Unicode tables to be written to the trail file in the installed ASCII single-byte CCSID. Data from EBCDIC tables is converted to this ASCII CCSID.

  • Specification of this parameter on a multi-byte DB2 z/OS subsystem causes Extract to process only ASCII and Unicode tables. Extract abends with an error if it encounters EBCDIC tables. Data from ASCII tables is written to the trail file in the installed ASCII mixed CCSID.

Either TRAILCHARSETASCII or TRAILCHARSETEBCDIC is required if the target is a multi-byte system. To replicate both ASCII and EBCDIC tables to a multi-byte DB2 z/OS target, process each character set with a different Oracle GoldenGate processing stream: one Extract, data pump, and Replicat for the ASCII tables and another Extract, data pump, and Replicat for the EBCDIC tables.

Default

Character data is written in the character set of the host table.

Syntax

TRAILCHARSETASCII