duplicate identifier(): error

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
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

duplicate identifier(): error

Post by tanaya.deshpande@tieto.co »

I have 3-4 DB2 stages 1 lookup and 1 dataset in my job

I am getting this error
Added field has duplicate identifier(): ActualDeliveryDate

RCP is disables at Project level..

what could be the reason ..??????
What I know is RCP is only for sequential file stage ,Fileset ..and external target and source..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: duplicate identifier(): error

Post by ray.wurlod »

tanaya.deshpande@tieto.co wrote:What I know is RCP is only for sequential file stage ,Fileset ..and external target and source..
RCP is available for almost every stage type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
antonyraj.deva
Premium Member
Premium Member
Posts: 138
Joined: Wed Jul 16, 2008 9:51 pm
Location: Kolkata

Post by antonyraj.deva »

Are you using SQL builder inside the DB2 stages in your job design?

This error occurs when you mention the same column twice. Try checking if you are using Column alias names inside DB2.
TONY
ETL Manager
Infotrellis India

"Do what you can, with what you have, from where you are and to the best of your abilities."
Post Reply