Capturing SQL Error code/message in transformer reject

legendkiller · Post by **legendkiller** » Fri Dec 07, 2007 7:28 am

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

chulett · Post by **chulett** » Fri Dec 07, 2007 7:53 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.