Decimal Compact / EBCDIC handling

przytula · Post by **przytula** » Tue May 11, 2004 3:33 am

I want to manipulate some fields in a before routine, reading the input file and creating output files. These fields are DEC Compacted EBCDIC.
Any idea how these can be checked, for specific values and put back another value to this fileld, that is still compatible with EBCDIC DEC COMP-3
The problem is that this field contains EBCDIC space (40) which is accepted as valid DEC COMP3, and this I want to transform to regular 00
Any sample/help appreciated.
Best Regards, Guy Przytula

thirupri · Post by **thirupri** » Wed May 12, 2004 6:16 am

Use the Complex File Format DataStage, specify the input file as EBCDIC for the NLS setting. Then you can use OConv(Iconv()) function in transformation to convert to decimal. Hope this will work.

Regards,