Reference Manual

10.2 HotFix 2
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0
- 10.2 HotFix 1
- 10.2

Back Next

Oracle Code Page Parameters

Oracle passes character data to PowerExchange based on the character set portion of the NLS_LANG environment variable. You must define the NLS_LANG environment variable. You might also need to specify an ORACLECODEPAGE statement in the dbmover.cfg configuration file.

If the NLS_LANG environment variable specifies UTF8 or AL32UTF8, PowerExchange determines the code page with which to process connection strings, SQL statements, column data, and parameter data.

If the NLS_LANG environment variable specifies a character set other than UTF8 or AL32UTF8, you must define the ORACLECODEPAGE statement in the dbmover.cfg configuration file.

The ORACLECODEPAGE statement determines the code pages that PowerExchange and PowerCenter use for an Oracle database during bulk data movement operations. These code pages must match the character set specified in the NLS_LANG environment variable.

Use the following syntax to enter this statement:

ORACLECODEPAGE=(tnsname_host,pwx_codepage,pc_codepage)

The statement contains the following positional parameters:

tnsname_host: Required. An entry in the Oracle tnsnames.ora configuration file for an Oracle database. The entry defines the database address that PowerExchange uses to connect to the database.
pwx_codepage: Required. A code page number or alias name that PowerExchange uses to identify a code page. To determine valid PowerExchange code page and alias values, use the ICUCHECK utility to generate report 5, “PowerExchange Code Page Names and Aliases.”
PowerExchange supports some common Oracle character set names as aliases to code pages.
pc_codepage: Optional. A name that controls the processing of the SQL statements that PowerExchange passes to Oracle on behalf of PowerCenter bulk data movement sessions. PowerExchange supplies a default that is usually suitable.
Do not specify this parameter except in special circumstances when the default does not work. For example, if you specify a user-defined ICU code page for the pwx_codepage parameter, you need to specify this parameter.

For example, if the NLS_LANG environment variable specifies Korean_Korea.KO16MSWIN949, define the following ORACLECODEPAGE statement in the dbmover.cfg file:

ORACLECODEPAGE=(KO102DTL,MS949)

You can specify up to 20 ORACLECODEPAGE statements, each for a separate database, in a dbmover.cfg file.

If PowerExchange uses the same NLS_LANG environment variable to access multiple Oracle databases, you do not need to specify a separate ORACLECODEPAGE statement for each database. Instead, specify a single ORACLECODEPAGE statement and leave the tnsname_host parameter blank. The specified code page then applies to all databases that have an entry in the tnsnames.ora file. The following example shows a statement without a tnsname_host parameter: