Error handling

mfanas · Post by **mfanas** » Thu Sep 28, 2006 4:37 am

Hi all. I'm new in Datastage development and I need to migrate data from a staging table to a final table on DB2. I need to only export data that conform to the business rules to the final table and all the rest sent to an error table. How can I achieve this, is Reject table appropriate for this and if yes how do I do it.

Thank you in advance.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 28, 2006 5:50 am

Use a Transformer stage output link constraint to enforce your business rule. Good rows are pushed out that output link; all other rows (the rejects) can be pushed out a second output link by making the second output list a "rejects" link.

mfanas · Post by **mfanas** » Thu Sep 28, 2006 8:56 am

Thanks Ray I'll try that...