capturing reasons of rejected rows in a table

rafik2k · Post by **rafik2k** » Sat Jun 23, 2007 4:06 pm

Presently I am capturing filtered and rejected rows into db2 table using following constraints at transfomer stage.

LNK_Write_Account_Mst_Filtered--->

Code: Select all

LNK_Write_Account_Mst.REJECTEDCODE = DSE.NOERROR And LNK_Write_Account_Mst.REJECTED

LNK_Write_Rejects--->

Code: Select all

LNK_Write_Account_Mst.REJECTEDCODE

where LNK_Write_Account_Mst is input link

My requirement is to capture also exact reason for each rejected rows into db2 table along with rejected rows.

Could you anyone of you let me know how to do this?

or any reference of the previous post would also help me.

Thanks in advance

chulett · Post by **chulett** » Sat Jun 23, 2007 5:09 pm

Look into all of the 'Link Variables' available. Put them all in a reject link and see which ones the DB2 stage actually populates under various conditions as not all stages are created equal. Depending on what you see there, you may very well find that to know the full 'reason' for the problem you'll need to farm the logs in a separate post-job step.