column import stage error=must be of type string or raw

dsisbank · Post by **dsisbank** » Thu Jan 25, 2007 9:53 am

Hi,
My job is like above
Oracle source stage-->column import st--->seq. file.

I have a column data type varchar2(4000).i store in it like that data
"0001","john ","istanbul"
and i want to separate this column like that
id name city
0001 john istanbul

for this,i use column import stage but i have error above

""column_import_1: Import field "DATA" must be of type string or raw. [new-impexp/field_import.C:245]""

my source is already varchar,how can i solve this?

bcarlson · Post by **bcarlson** » Thu Jan 25, 2007 12:34 pm

I haven't used Oracle with DataStage. Perhaps DataStage doesn't like the incoming datatype of 'varchar2'. Could this be cast as a different string type in your query?

Just a guess...

Brad.

DSguru2B · Post by **DSguru2B** » Thu Jan 25, 2007 1:18 pm

Have you tried getting rid of the column import stage and directly loading to the sequential file with quote character set to none and delimiter set to space ?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 25, 2007 4:00 pm

Or use a Transformer stage and Field() functions to parse it?

As you've seen the Column Import stage is fairly particular about the input column you ask it to parse.

dsisbank · Post by **dsisbank** » Fri Jan 26, 2007 6:42 am

i use transformer stage before column import stage,and convert the data from stringtoraw using transformer function.Column import stage worked well.problem is solved.
and also second way ,field() function helps to be solved
thanks everbody answered