NAMECCSID
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 session, use the SET NAMECCSID
command.
To view the current CCSID, use the SHOW
command. If the CCSID is not
set through the Admin Client session or through the parameter
NAMECCSID
, the SHOW
value will be
DEFAULT
.
Default
DEFAULT
Syntax
NAMECCSID {CCSID
| DEFAULT}
Example
NAMECCSID 1141