Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

Oracle Code Page Parameters

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:
ORACLECODEPAGE=(,MS1252)
If you enter an incorrect PowerCenter code page value, the ODLNumResultCols routine usually reports Oracle return code 911.