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?
patonp wrote:
Any suggestions as to how I can perform the conversion within a transformer?
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.
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:
patonp 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?
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 job
you can call an parallel routine that you can write in C that does a simple efficient translation from EBCDIC to ASCII
So does this mean that there is no functionality within the parallel toolset to perform this type of conversion after the data has been read from a file?