Reading special characters from DB2 loading in Oracle

adis · Post by **adis** » Wed Jul 29, 2009 7:44 am

Hi,
I encountring a problem while reading special charachters like trademark sign, registered signs, and other special signs stored in DB2 database. When quried from DB2 database and loaded into Oracle database, the characters are translated into junk characters, like inverted question marks etc.
Is there any function available within datastage to translate special charachters as it is from DB2 to Oracle database. Data is not available in flat files its stored in DB2 tables.

Thanks!

ArndW · Post by **ArndW** » Wed Jul 29, 2009 7:53 am

If you keep the same character set throughout there will be no problem with such characters.

1. What is the encoding used in your DB2 table? Have you told that to DataStage?
2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well?

When you fix #1 and #2 your data will be successfully transferred.

adis · Post by **adis** » Wed Jul 29, 2009 8:14 am

ArndW wrote:If you keep the same character set throughout there will be no problem with such characters.

1. What is the encoding used in your DB2 table? Have you told that to DataStage?
2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well?

When you fix #1 and #2 your data will be successfully transferred.

Thanks for your quick Reply. I will check that.

adis · Post by **adis** » Wed Jul 29, 2009 8:16 am

ArndW wrote:If you keep the same character set throughout there will be no problem with such characters.

1. What is the encoding used in your DB2 table? Have you told that to DataStage?
2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well?

When you fix #1 and #2 your data will be successfully transferred.

Thanks for your quick Reply. I will check that.