Valid for

GLOBALS, Extract, Replicat, DEFGEN for DB2 on IBM i

Description

Use the NAMECCSID parameter to specify the CCSID (coded character set identifier) of the database object names stored in the SQL catalog tables. The SQL catalog tables are created with the CCSID of the system, but the actual database object names could be represented in the catalog with characters from a different CCSID. The catalog does not indicate this difference when queried, and therefore Oracle GoldenGate could retrieve the name incorrectly unless NAMECCSID is present to supply the correct CCSID value.

To set the CCSID for a GGSCI session, use the SET NAMECCSID command.

To view the current CCSID, use the SHOW command. If the CCSID is not set through the GGSCI session or through the parameter NAMECCSID, the SHOW value will be DEFAULT.

Default

DEFAULT

Syntax

NAMECCSID {CCSID | DEFAULT}

CCSID

A valid DB2 for i coded character set identifier that is to be used for object names in catalog queries.

DEFAULT

Indicates that the system CCSID is to be used for object names in catalog queries.

Example

NAMECCSID 1141