Reference Manual

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

Back Next

Example 2. Using DB2 Data Maps to Remap CCSID 37 to Thai CCSID 87

In this example, as in the previous one, you need to consolidate data from different locations into DB2 for i5/OS tables. The CCSID is set to 37, but the data is in the EBCDIC Thai code page at internal code page number 222 which uses ICU converter ibm-838_P100-1995.

Add a data map with an access method of DB2. Select the

Import Record Definitions

option to import the columns for the table.

Amend the code pages for each CHAR and VARCHAR column to the required code page, or set the required code page in the data map properties so it affects all CHAR and VARCHAR columns in the map.

From the PowerExchange Navigator, run the DTLDESCRIBE COLUMNS command to verify that the data is described using the required internal code page number.

From the PowerExchange Navigator, run a database row test to view the data.

Create and run a PowerCenter workflow to copy the data to a flat file in UTF-8. Then view the flat file to verify that no characters were lost.

If you are capturing DB2 change data, add a user-defined extraction map. To add a user-defined extraction map, open the extraction group in the PowerExchange Navigator. On the Extraction Group tab in the Resource Explorer, right-click the extraction group and click

Add Extract Definition

After you add the extraction map, merge the data map with the extraction map. In this way the change data will also use the changed code page.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

Example 2. Using DB2 Data Maps to Remap CCSID 37 to Thai CCSID 87

Example 2. Using DB2 Data Maps to Remap CCSID 37 to Thai CCSID 87