DSXchange

ArndW sorry... Following error when output is Sequential File. "Attempting to Cleanup after ABORT raised in stage". Also with NONE NLS Map in Source stage...job is sucessful but data is written in question marks "?????" to text file. I have changed the text file to UTF-8 but same...

I have tried it with MS1256 but same error. Also I have tried with UTF-8 and ohter as an hit and trial method but same error for all NLS Map selection except NONE.

Are you sure that your selected character sets are correct? I am not sure about the Russian character set to be used in DataStage but I am using KOI8-R. Also problem occurs with input stage NLS Mapping. Is the arabic data in your source perhaps already stored correctly? Yes, because the same source ...

The HEX value for first ? is 203F. Also this is the same HEX value for this data in source database. English data in source db is fine but Arabic data in source db is like '????". My concern is to get these question marks to be translated in Arbaic because these are Arabic data.

ArndW, I am not using "View data" functionality but in SQL Plus also it shows "???????????" for this data. The same data in other application is in Arabic form.

In source data type for this column is varchar2(240)... Not "LOB". Also I have tried with LongVarchar data type but same error.

It is already Varchar2(1000)..I have mentioned in post

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 targ...

I have used varchar2(32 char) but same error. Can you please tell me which oracle data type I should use?

After some changing now I am getting this message:
At row 1, link "OutLink"
Inserted value too large for column, row rejected.

After some changing now I am getting this message:
At row 1, link "OutLink"
Inserted value too large for column, row rejected.

The target Oracle database Character set is
NLS_CHARACTERSET = AR8MSWIN1256 and
NLS_NCHAR_CHARACTER = AL16UTF16

Thanks Ray, But i am not Premium member.

Thanks Graig,

I dont want to use subquery but i want to load these values of subquery in a Parameter or in a file and then want to use that Parameter or file

How?

Hi all, From my Question, you will find me as a new user of DS. I have to load the subset of a source table data into target table but in where condition i want to get data dynamically e.g SELECT * FROM TABLE1 WHERE TABLE1.COL1 IN (1,2,3,4,5) I want to get the values of COL1 dynamically from another...