Posted: Mon Jul 10, 2006 2:59 am
Hi Pxlearn,
i have also faced a similar problem.At last I found that the problem is not with the Datastage. Changing the NLS map won't solve your problem. Tell me which server OS you are using.
You check these things at your end.
1.while loading from Seq File to OCI Stage
You should able to see all the data with Special Charecters.
2.Open the File in Unix environment by vi command
In place of Arabic Charecters you should observe numbers or different symbols.
3.while reading from oci and writing to seq file or oci stage
You should able to observe ??
Then the Problem is at your server end. Change the settings at server end so that you can able to view arabic charecters on unix prompt when you view the file.
Note: Proper NLS settings are required but that does'nt mean that by changing the nls settings will solve ur problem unless and until your language settings are not set at OS level.
i have also faced a similar problem.At last I found that the problem is not with the Datastage. Changing the NLS map won't solve your problem. Tell me which server OS you are using.
You check these things at your end.
1.while loading from Seq File to OCI Stage
You should able to see all the data with Special Charecters.
2.Open the File in Unix environment by vi command
In place of Arabic Charecters you should observe numbers or different symbols.
3.while reading from oci and writing to seq file or oci stage
You should able to observe ??
Then the Problem is at your server end. Change the settings at server end so that you can able to view arabic charecters on unix prompt when you view the file.
Note: Proper NLS settings are required but that does'nt mean that by changing the nls settings will solve ur problem unless and until your language settings are not set at OS level.