Now, you can save your searches to easily repeat search requests.
Saving a search is as easy as 1-2-3:
1. Perform a search. The Search Results page opens. 2. Optionally, choose filters or update your search term. 3. Click Save Search.
You can access saved searches from a list next to the Search field that appears on every page. Saved searches store the search term and any search filters that you apply.
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
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.
Repeat steps 3 through 5 with the DB2 change data.