Error during Arabic data loading from text file
Moderators: chulett, rschirm, roy
This probably means that while you have used MS-1256 within DataStage, the Oracle Database or output table has another character set defined which cannot hold some character that is available in MS-1256. What are your Oracle NLS settings (check in Oracle, not DataStage)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If you disable operator combination, which stage is the one generating the message - the input or output one?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
For NLS applications you should always make sure that, in Oracle, you declare strings using VarChar2(32 Char) so that 32 characters can be used. If you use the default, then just 32 bytes would be reserved and you couldn't store 32 multibyte characters into that strnig.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Varchar2 is the appropriate type for string values up to 4000 characters. I used "32" as an example - you might need a longer string - what is your input string maximum length?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Maximum length is just 500.
Please consider new scanrio:
I have created table t1: c1 number(10), c2 varchar2(1000)
I have inserted Arabic word in c2 and it is fine and display is SQL Plus is also fine as Arabic word.
I have also created a new ETL job that loads data from table t1 to table t2 in target database just to check NLS Mapping.
I am getting the following message in Input Stage:
"Oracle data type not presently supported".
Any Help??????????/
Please consider new scanrio:
I have created table t1: c1 number(10), c2 varchar2(1000)
I have inserted Arabic word in c2 and it is fine and display is SQL Plus is also fine as Arabic word.
I have also created a new ETL job that loads data from table t1 to table t2 in target database just to check NLS Mapping.
I am getting the following message in Input Stage:
"Oracle data type not presently supported".
Any Help??????????/
What datatype did you specify in Oracle? Could it be a long type or blob? Also, use "VarChar2(1000 char)"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>