Home Code Page rules PWX Listener job settings

PWX Listener job settings

Written by 
Rate this item
(3 votes)

Informatica PowerExchange can integrate PowerCenter with i5/OS. PWX listener job which runs on I5/OS (as/400, iseries) takes part in code page conversion. Setting CCSID for the job equal to 65535 causes peculiar errors. It is due to lack of the code page conversion when there is no interaction witch physical files. For instance, following sql sentence written in Source Qualifier SQL Overide

 

select  'something'  from existingtable

 

returns to PowerCenter string 'something' but as HEX representation of the string being in EBCDIC code page. It means we receive not 9 chatacters but 18. Therefore, we can have erros informing about field to long while reading data or confusing, unexpected string of characters (for instance HEX string).

 

The soluting is setting code page other then 65535. Of cource the code page should be compatible with data read from the i5/OS machine.    

Read 3511 times Last modified on Sunday, 01 February 2015 19:37
More in this category: « False code page issue.