Hi All,
I'd like to convert a string from EBCDIC to ASCII within a Transformer stage. If I were developing this code in Server Edition, I'd simply use the ASCII() function. How can I do the same thing in Parallel Edition?
Thanks!
Peter
EBCDIC to ASCII Conversion
Moderators: chulett, rschirm, roy
From the transformer you can call an parallel routine that you can write in C that does a simple efficient translation from EBCDIC to ASCII. A simple while loop and a couple arrays would do. The advantage of doing this is you can call the function conditionally for certain fields based on other stage variable logic.patonp wrote: Any suggestions as to how I can perform the conversion within a transformer?
The Sequential flat file also has EBCDIC parsing abilities that rival the CFF.
Definitely the derivation functions for handling EBCDIC seem to have dissapeared. If you require some conditioinal application of EBCDIC to ASCII translation you might want to employ a strategy similar to what's suggested in this link:
viewtopic.php?t=104116&highlight=
Greg
Re: EBCDIC to ASCII Conversion
parallel transform doesnt have ASCII function ..but the BASIC transform does. The simplest solution would be , if you can afford the performance loss, using this stage in your parallel jobpatonp wrote:If I were developing this code in Server Edition, I'd simply use the ASCII() function. How can I do the same thing in Parallel Edition?
thank you
- prasad
- prasad
That is correct, unless you convert the data while reading the PX engine doesn't have builtin functionality to perform that conversion.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>