Reading special characters from DB2 loading in Oracle
Posted: 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!
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!