Hi,
I have job which loads data into db2 table via db2 stage. While loading some of the reords are getting rejected becuase pr primary key constriant. I am able to capture these records in transformer link ( reject link) can any body tell me how to capture SQL error code thrown by db2 in Transfermer link.
Regards
Legend killer
Capturing SQL Error code/message in transformer reject
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Sun Nov 21, 2004 2:24 am
Seems to depend on the stage author, what exactly gets captured where. Suggest you create a test and include all of the 'Link Variables' in the reject record, see which has what you are looking for. REJECTEDCODE? SQLERR? Don't recall what all is there.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers