Converting EBCDIC to ASCII in Transformer Derivations

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gsherry1
Charter Member
Charter Member
Posts: 173
Joined: Fri Jun 17, 2005 8:31 am
Location: Canada

Converting EBCDIC to ASCII in Transformer Derivations

Post by gsherry1 »

Hello Forum,

I have a need to convert a string from EBCDIC to ASCII for the purposes of doing some logic in stage variables. I would like to do this in a Parallel transformer if possible.

I was adding the EBCDIC attribute to the schema file, and this was allowing my stage variable logic to evaluate properly, however in some cases DS came across some non-ebcdic character hex values and decided to convert them to something that it thought I would like. I did not like this, as it is important to me that the original data be placed in output and be unaltered.

I see that there are some convenient functions like ASCII and EBCDIC in Server edition, and was wondering if there was a parallel equivalent before I switched my job to use the BASIC transformer to gain access to these functions.

Thanks in advance,

Greg
Post Reply