EBCDIC Data Reading from DB2

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
edward_m
Charter Member
Charter Member
Posts: 257
Joined: Fri Jun 24, 2005 9:34 am
Location: Philadelphia,PA

EBCDIC Data Reading from DB2

Post by edward_m »

ALL,

I did notice some of the tables data is in EBCDIC format on AS/400, i am using DB2 stage to connect to As/400,please let me know where to define EBCDIC definition in DB2 stage properties or is there a way to convert this EBCDIC format data in transformer..

Thanks in advance..
Top
l_homme_de_rio
Participant
Posts: 17
Joined: Fri Jul 30, 2004 1:16 am

Re: EBCDIC Data Reading from DB2

Post by l_homme_de_rio »

edward_m wrote:ALL,

I did notice some of the tables data is in EBCDIC format on AS/400, i am using DB2 stage to connect to As/400,please let me know where to define EBCDIC definition in DB2 stage properties or is there a way to convert this EBCDIC format data in transformer..

Thanks in advance..
Hi Edward,
Get the copy books and have a look to the "Readcobol" executable in te PX bin dir
It's brilliant !
Michel
Top
edward_m
Charter Member
Charter Member
Posts: 257
Joined: Fri Jun 24, 2005 9:34 am
Location: Philadelphia,PA

Post by edward_m »

i am able to see the ebcdic data using db2 plugin stage and want to define ebcdic format in db2 properties,please let me know how???
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”