When inserting into an ODBC stage I can write rejected records to an error file using a Reject link and a constraint that looks like link.REJECTEDCODE 0 -- this works fine.
When I try to do the same thing with a DSDB2 stage it doesn't work -- even though DB2 fails to insert some records, they are not written to the error file.
Is this a bug with the DSDB2 stage or is there some other constraint I can use to make it work?
I am using DSDB2 in preference to ODBC because I want to use the BeforeSQL and AfterSQL to do some pre- and post-processing -- this works well using DSDB2 and does not seem so straight-forward using ODBC.