Error - Dropping component "sqlcode" because of a

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

Post Reply
adis
Participant
Posts: 13
Joined: Tue Feb 13, 2007 11:17 am

Error - Dropping component "sqlcode" because of a

Post by adis »

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 »

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 »

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 »

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 »

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.
Post Reply