DSXchange

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

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.