Hi,
i got an error "pl_id is already kept" while executing a ds job. Please help me out. Thanks in advance.
cheers,
bhasan
*Note* Subject changed to be more descriptive - Content Editor
pl_id is already kept
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
My guess (since you did not provide any information about your job design) is that you have a Modify stage in which both of the following are true.
(1) Field pl_id appears in a KEEP specification or does not appear in a DROP specification.
(2) There is a specification that derives a value for field pl_id.
You can't have both.
In future can you please try to devise a subject that more accurately describes the actual problem? This will assist future searchers. For example this thread could have had a subject like "... is already kept".
My guess (since you did not provide any information about your job design) is that you have a Modify stage in which both of the following are true.
(1) Field pl_id appears in a KEEP specification or does not appear in a DROP specification.
(2) There is a specification that derives a value for field pl_id.
You can't have both.
In future can you please try to devise a subject that more accurately describes the actual problem? This will assist future searchers. For example this thread could have had a subject like "... is already kept".
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.
Re: pl_id is already kept
Hi,
Thanks for your reply.
Actually the job is designed to implement SCD type2 (using flag y/n), in that i had used the Oracle stage where i was allowed to upsert(insert as well as update). In that i used the same id for refering the rows. I guess i got that error in that place. Can you please help me out in this error. Thanks in advance.
Regards,
Bhasan.
Thanks for your reply.
Actually the job is designed to implement SCD type2 (using flag y/n), in that i had used the Oracle stage where i was allowed to upsert(insert as well as update). In that i used the same id for refering the rows. I guess i got that error in that place. Can you please help me out in this error. Thanks in advance.
Regards,
Bhasan.