Posted: Wed Oct 02, 2002 9:02 pm
Create another output link, mark it as handling rejected rows but do not have a constraint expression on it.
It will then handle rows rejected by the database, and you can use the SQLSTATE, DBMSCODE and LASTERR link variables from output links executed earlier to supply diagnostic information.
Naturally, the [Rejects] output link must be the final link executed in the Transformer stage; modify link execution order if this is not the case.
It will then handle rows rejected by the database, and you can use the SQLSTATE, DBMSCODE and LASTERR link variables from output links executed earlier to supply diagnostic information.
Naturally, the [Rejects] output link must be the final link executed in the Transformer stage; modify link execution order if this is not the case.