Use SET NAMECCSID to set the CCSID (coded character set identifier) of the GGSCI session when you need to issue commands for tables in a DB2 for i database. This command is required if the CCSID of the object names stored in the SQL catalog tables is different from the CCSID of the system. The SQL catalog tables are created with the CCSID of the system, but the actual database object names could be represented with 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 GLOBALS, Extract, Replicat, or DEFGEN, use the NAMECCSID parameter.

SET NAMECCSID is not valid if the DBLOGIN command was previously issued, because that command affects the GGSCI session. To issue SET NAMECCSID after a DBLOGIN command, restart GGSCI.

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.

Syntax

SET NAMECCSID {CCSID | DEFAULT}

CCSID

A valid DB2 for i coded character set identifier that is to be used for the GGSCI session.

DEFAULT

Indicates that the system CCSID is to be used for the GGSCI session.

Example

SET NAMECCSID 1141