Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the relationship of the codepage used by a Custom transformation and the PowerCenter Integration Service code page?
Answer

ASCII Data Movement Mode

By default when the PowerCenter Integration Service is running in ASCII data movement mode the code page of the Custom transformations is also ASCII.
You can write the external procedure code to request the data in UCS-2 format using the INFA_CTChangeStringMode() function. When you use this function, the procedure must pass only ASCII characters in UCS-2 format to the Integration Service.
Do not use the INFA_CTSetDataCodePageID() function when the PowerCenter Server runs in ASCII mode.

Unicode Data Movement Mode

By default, when the PowerCenter Integration Service is running in Unicode mode, the code page of the Custom transformation procedure is UCS-2, but the Integration Service only passes characters that are valid in the Integration Service code page.
In this scenario character conversion does not occurs, instead only data which is compatible to UCS-2 is passed to the Custom transformation.
Data is switch between the PowerCenter Server code page (for example MS932 ) and UCS-2 (the Custom transformation code page).

You can avoid this switching by writing the external procedure code to request the data in MBCS using the INFA_CTChangeStringMode() (CT API) function. When the external procedure requests the data in MBCS, the PowerCenter Server passes the data in the PowerCenter Server code page.


More Information

When you use the INFA_CTChangeStringMode() function, you can write the external procedure code to request the data in a different code page from the PowerCenter Server code page using the INFA_CTSetDataCodePageID() function. The code page you specify in the INFA_CTSetDataCodePageID() function must be two-way compatible with the PowerCenter Server code page.


Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
For more details refer to the Transformation Guide > "Custom transformation".

Attachments

Last Modified Date:12/21/2009 5:19 PMID:17858
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)