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..
duplicate identifier(): error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: duplicate identifier(): error
RCP is available for almost every stage type.tanaya.deshpande@tieto.co wrote:What I know is RCP is only for sequential file stage ,Fileset ..and external target and source..
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
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.
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."
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."