Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
das_nirmalya
Participant
Posts: 59 Joined: Thu Mar 20, 2008 12:11 am
Post
by das_nirmalya » Wed Oct 15, 2008 6:24 pm
When i am trying to delete record from a table in Oracle enterprise stage select Write Method : Delete rows .
It is giving error :Unable to use a record for update.
Please sugest.
nsd
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 15, 2008 7:25 pm
Suggestion: Post the
actual, unedited, full error. Is it a DataStage message or one from Oracle?
-craig
"You can never have too many knives" -- Logan Nine Fingers
das_nirmalya
Participant
Posts: 59 Joined: Thu Mar 20, 2008 12:11 am
Post
by das_nirmalya » Wed Oct 15, 2008 7:31 pm
chulett wrote: Suggestion: Post the
actual, unedited, full error. Is it a DataStage message or one from Oracle? ...
F_JDE_FACT,1: Unable to use a record for update.
This is a DataStage message.
nsd
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Oct 15, 2008 7:46 pm
And was any record in fact provided to the stage on node #1? If you only provided one record in your design, then it was unwise to run that stage on more than one node.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Neerav
Participant
Posts: 2 Joined: Mon Mar 26, 2007 8:50 am
Post
by Neerav » Fri Jun 18, 2010 2:00 pm
If you are trying to delete record and have a child depenedency you will get the message "unable to use a record for update" in oracle enterprise stage
Neerav Jain
nagarjuna
Premium Member
Posts: 533 Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago
Post
by nagarjuna » Fri Jun 18, 2010 2:31 pm
These type of errors you will face incase you are trying to update a nonexistant record
Nag