DSXchange

Hi,
i am trying to read data from db2 v8 on AIX to oracle database using
db2 wire protocol, the tables contains Arabic data, the problem is the
Arabic data coming as ??????, the code page for the db2 is 1208.
i am using NLS =UTF8 in the ODBC stage.

any help is very appreciated.

(i searched the forum and i did not find anything helpful for me)

thanks in advance

Try below links, may be useful!.

http://staff.in2.hr/denis/oracle/nls_data.html

http://www.microsoft.com/globaldev/nlsweb/default.mspx

Datastage will display always in ??? question marks, you load the data to the oracle database then use the sqlplus to see the data. or try to change in the registry setting NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256

thanks for all valuable input,
sorry for replaying late, bcz our weekend is Thursday and Friday,

sia_999, i am seeing this ???? and unreadable characters using TOAD and sqlplus, i know we cannot see it from inside datastage.
any other solutions/ideas?

i moved one step that i can see correct data when loading it to sequential file, my problem now is to insert it correctly in the oracle target DB, i test all available NLS, but i get same result.
thanks for your replaying time.

waklook wrote:thanks for all valuable input,
sorry for replaying late, bcz our weekend is Thursday and Friday,

sia_999, i am seeing this ???? and unreadable characters using TOAD and sqlplus, i know we cannot see it from inside datastage.
any other solutions/ideas?

i moved one step that i can see correct data when loading it to sequential file, my problem now is to insert it correctly in the oracle target DB, i test all available NLS, but i get same result.
thanks for your replaying time.

you need to do two things

first make sure that inserting some test data from toad and select the information, if it display correctly then the second step is to findout what is the code page of oracle is set, by issueing this command.
SELECT * FROM sys.V_$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
after that source should be utf8 and the destination should be the oracle nls_characterset, I hope this will resolve your problem.

Thanks again sia_999;

i did insert one row and it's fine.
the query output was 'AR8ISO8859P6',
i used 'IS08859-6' for the target and 'UTF8' for the source and no succeed.

waklook wrote:Thanks again sia_999;

i did insert one row and it's fine.
the query output was 'AR8ISO8859P6',
i used 'IS08859-6' for the target and 'UTF8' for the source and no succeed.

you can try one more thing add the two lines to the dsenv file as

NLS_LANG="AMERICAN_AMERICA.AR8ISO8859P6"
NLS_LANGUAGE="AMERICAN_AMERICA.AR8ISO8859P6"

then restart the etl service.

our datastage engine installed on windows server,i am not finding the dsenv file, where can i find it on windows?

There is no dsenv file on Windows-based DataStage servers. You can set up environment variables using Control Panel > System > Environment.
(Depending on which version of Windows, Environment may be a command button on one of the tabs in the System dialog.)

thanks to Srimitta, Sia_999, Ray and for all,

i have solved the problem by using 'UTF8' - source and 'MS1256' - target.

i will mark this issue as closed

Which means you should scroll up to your first post and mark the topic as 'Resolved'.