Reporting rejected records in DB2

jcoley · Post by **jcoley** » Wed May 14, 2003 3:33 am

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.

Regards,
Jeremy.

chulett · Post by **chulett** » Wed May 14, 2003 6:39 am

Try checking the 'Reject Row' check-box *without* adding a contraint as well and see if it works that way.

-craig

jcoley · Post by **jcoley** » Wed May 14, 2003 7:26 am

Having a reject link with no constraint has the same effect - no records written to the error file.

I've tried various other combinations of constraints and get either no records or all records written to the error file.

Regards,
Jeremy.

chulett · Post by **chulett** » Wed May 14, 2003 8:39 am

Then, unless someone else chimes it, it sounds like a bug (the OCI stage had a similar issue once). I'd report it to Ascential support.

-craig

bigpoppa · Post by **bigpoppa** » Thu May 15, 2003 10:49 am

Hi. If you report the bug, could you keep us posted on the fix? We're trying to do the same thing here.. Thanks, BP