DB2 conversion from EBCIDIC to ASCII codeset

Indrajit Dasgupta

DB2 conversion from EBCIDIC to ASCII codeset

We have data on DB2 tables on mainframe. While loading this data into a database on ASCII character set we are getting errors indicating invalid character. I believe this is related to EBCIDIC to ASCII conversion. Can you please suggest how I can apply the conversion while pulling the data?

Regards,

Tom Bauch

RE: DB2 conversion from EBCIDIC to ASCII codeset
(in response to Indrajit Dasgupta)

What are you using for the data transfer?   

Tom Bauch

RE: DB2 conversion from EBCIDIC to ASCII codeset
(in response to Indrajit Dasgupta)

Are you using DB2 Connect, or something else?    DB2 Connect will handle the translation (one of its main functions).

Indrajit Dasgupta

RE: DB2 conversion from EBCIDIC to ASCII codeset
(in response to Tom Bauch)

We are in the process of evaluating a solution. We plan to pull using Informatica Power Center. This does not have conversion when reading from a DB2 database using EBCIDIC codeset. We will definitely try out the DB2 Connect. Thanks a lot.