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
adis
Participant
Posts: 13 Joined: Tue Feb 13, 2007 11:17 am
Post
by adis » Thu Feb 12, 2009 11:13 am
Hello All,
I have 2 Oracle Enterprise Stages in my job for inserting records. Both have reject links with default output column "sqlcode" along with other columns. When I run my job I get a warning -
"When checking operator: Dropping component "sqlcode" because of a prior component with the same name.".
Since the column "sqlcode" is default when I have a reject link I cannot remove it from output.
Thanks,
Rishi
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Feb 12, 2009 2:08 pm
Where do the reject links go?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
adis
Participant
Posts: 13 Joined: Tue Feb 13, 2007 11:17 am
Post
by adis » Wed Feb 25, 2009 11:43 am
ray.wurlod wrote: Where do the reject links go? ...
The reject writes to text files.
Thanks!
Rishi
girija
Participant
Posts: 89 Joined: Fri Mar 24, 2006 1:51 pm
Location: Hartford
Post
by girija » Wed Feb 25, 2009 11:53 am
Do you have separate file for two link?
Check RCP check box in your job.
adis
Participant
Posts: 13 Joined: Tue Feb 13, 2007 11:17 am
Post
by adis » Wed Feb 25, 2009 12:09 pm
girija wrote: Do you have separate file for two link?
Check RCP check box in your job.
Yes, seperate files for 2 links.
I will check RCP.