Oracle Stage Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
legendkiller
Participant
Posts: 60
Joined: Sun Nov 21, 2004 2:24 am

Oracle Stage Error

Post by legendkiller »

I am using Column Import Stage after Oracle stage getting following error. I have provided Ora_Sql_Data as an input column to Column Import Stage:

##E TOIX 000000 13:46:02(003) <Column_Import_80> Import field "Ora_Sql_Data" was not found in the input data set schema.

Thanks,
Ashish
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Can you give more details, Version yada, yada,.....
Ashish, do you want this in the FAQ?
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
legendkiller
Participant
Posts: 60
Joined: Sun Nov 21, 2004 2:24 am

Post by legendkiller »

What I want to do is: Read whole sql output as one column and then at column import stage based on schema file provided convert it to columns. This I have to use since we cannot provide schema file in Oracle Enterprise Stage.

I hope above text will help you in understanding the problem exactly.

Thanks,
Ashish
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Let's start over, Narasimha was too subtle with his FAQ question. Post this in the proper forum so we know what version, O/S, etc you have. This is not the proper forum.

Then someone can attempt to answer your question more better. Don't forget the 'yada yada' part. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply