Error handling
Posted: Thu Aug 28, 2008 7:17 am
Hi
I want to design a job that inserts rows into DB2 by using a relational stage,
Whenever a row rejected from the database for any reason, I want to write it into a file that collects the rejected rows,
I use the offer reminded in the forum (linkname.REJECTEDCODE = DSE_TRXLINK) on the constraint for the link of the file,
but then only the first row is written into it, and then the program aborts.
I want to collect all the rejected records,
Is there any way for me to determine when the program aborts and when not?
I want to design a job that inserts rows into DB2 by using a relational stage,
Whenever a row rejected from the database for any reason, I want to write it into a file that collects the rejected rows,
I use the offer reminded in the forum (linkname.REJECTEDCODE = DSE_TRXLINK) on the constraint for the link of the file,
but then only the first row is written into it, and then the program aborts.
I want to collect all the rejected records,
Is there any way for me to determine when the program aborts and when not?