DSXchange

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..

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

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???