Reference Manual

10.5.5
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

How PowerExchange Determines Internal Code Page Numbers by Data Source

PowerExchange uses internal code page numbers to uniquely identify code pages.

PowerExchange uses the internal code page numbers in many contexts, such as the following situations:

Exchanging control, data, and SQL code pages between the PowerExchange Listener and a calling application when processing open requests that are sent across the network.

Performing a SQL DTLDESCRIBE operation that processes CHAR and VARCHAR columns when importing metadata.

Processing an NRDB data map that defines code pages for fields and the entire map.

You can use the ICUCHECK utility to list the defined code page numbers.

The following table describes how the default internal code page numbers are derived by source or target type:

Source or Target Type	How Code Page Numbers Are Derived
DB2 on i5/OS	PowerExchange determines the internal code page number from the CCSID of the column and code page aliases. Optionally, columns that have no CCSIDs can be mapped to CHAR columns with code pages using the optional the DB2_BIN_CODEPAGE and DB2_BIN_AS_CHAR configuration statements. Otherwise, these columns are mapped to BIN columns and can only be processed in hexadecimal format.
DB2 on z/OS bulk data movement	For each source or target DB2 subsystem, PowerExchange determines the internal code page numbers for data columns based on the column CCSIDs and the DB2CODEPAGE statement in the DBMOVER configuration file. For single-byte columns, the internal code page number is based on the CCSID of the column and the first `sbcs_ccsid` value in the EBCDIC_CCSID or PLAN_CCSID parameter of the DB2CODEPAGE statement. For graphic double-byte columns, the internal code page number is based on the CCSID of the column and the `graphic_ccsid` value in the EBCDIC_CCSID or PLAN_CCSID parameter of the DB2CODEPAGE statement. For mixed-byte columns, the internal code page number is based on the CCSID of the column and the `mixed_ccsid` value in the EBCDIC_CCSID or PLAN_CCSID parameter of the DB2CODEPAGE statement.
Nonrelational bulk data movement	PowerExchange determines the internal code page number in the following order: The code page of the field from which the column was derived. This code page and field are specified in the data map. The code page of the data map. The CODEPAGE parameter for the data control code page, on the server where the NRDB access method runs.
Nonrelational CDC	PowerExchange determines the internal code page number in the following order: The code page of the field from which the column was derived. This code page and field are specified in the data map. The code page of the data map. The CODEPAGE parameter for the data control code page, on the server where the NRDB access method runs. PowerExchange records the code page of a field or data map in the CCT file when you create a capture registration.
Oracle bulk data movement	PowerExchange determines the internal code page number from the character set portion of the NLS_LANG environment variable. Optionally, you can use the ORACLECODEPAGE parameter in the DBMOVER configuration file.
Oracle CDC	The PowerExchange internal code page for the columns from which changes are captured is always UTF-8.
Microsoft SQL Server	PowerExchange determines the internal code page number from the collation sequence of the database.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

How PowerExchange Determines Internal Code Page Numbers by Data Source

How PowerExchange Determines Internal Code Page Numbers by Data Source