EBCDIC to ASCII Conversion
Moderators: chulett, rschirm, roy
EBCDIC to ASCII Conversion
My source files are from mainframes and all are in EBCIDC format. Do i need to convert them to ASCII for using the file in datastage. If yes, is there support from datastage in doing so & how expensive is the operation (in terms of coding effort?). Will it have a performance issue?
Don't know how familiar you are with dealing with EBCDIC stuff, but just in case... apologies if this is old news.
Only convert 'unpacked' fields to ASCII. If you have any packed fields (COMP-1 or COMP-3 fields, for example), they need to be handled separately and *not* converted. There are routines in the SDK for handling packed fields.
-craig
Only convert 'unpacked' fields to ASCII. If you have any packed fields (COMP-1 or COMP-3 fields, for example), they need to be handled separately and *not* converted. There are routines in the SDK for handling packed fields.
-craig
Viji,
If your mainframe EBCDIC files are completely composed of character fields, then you should be able to just perform an ftp stage with mode set to ascii. Otherwise, you can follow Craigs advise and perform an ftp stage in binary mode into a transformer stage with output derivations of ascii(INPUT.VARNAME) or use the DS transforms SDK's for packed decimal, binary, or zoned numeric, all signed or unsigned. The trick to success of the ftp is:
1. turn on match data to metadata
2. binary mode
3. fixed width fields
4. may need to adjust line termination (none or DOS)
5. on the columns tab for the ftp make sure that the display column is filled in with the same value as width....VERY IMPORTANT...
(width and display should match the actual byte count of the mainframe field)
The rest is basic DS
Hope this helps,
Steve
If your mainframe EBCDIC files are completely composed of character fields, then you should be able to just perform an ftp stage with mode set to ascii. Otherwise, you can follow Craigs advise and perform an ftp stage in binary mode into a transformer stage with output derivations of ascii(INPUT.VARNAME) or use the DS transforms SDK's for packed decimal, binary, or zoned numeric, all signed or unsigned. The trick to success of the ftp is:
1. turn on match data to metadata
2. binary mode
3. fixed width fields
4. may need to adjust line termination (none or DOS)
5. on the columns tab for the ftp make sure that the display column is filled in with the same value as width....VERY IMPORTANT...
(width and display should match the actual byte count of the mainframe field)
The rest is basic DS
Hope this helps,
Steve