capture rejected records and reason forrejection

dodda · Post by **dodda** » Wed May 13, 2009 8:23 am

Hello

I have a requirement where i am inserting the data into a database(oracle) from Flat File. In my scenario i need to capture the rejects in a sequential File and the reason for rejection appended to the every row that is rejected in a rejected File.

appreciate if you can help me.

thanks

ArndW · Post by **ArndW** » Wed May 13, 2009 8:39 am

When you put an output link from your target Oracle stage and enable rejects, the SQL error code is added automatically to the output link.

nagarjuna · Post by **nagarjuna** » Wed May 13, 2009 11:39 am

Dodda ,

i assume that you are using upsert mode .So , put a reject link and automatically you can get sqlcode with that .

dodda · Post by **dodda** » Wed May 13, 2009 2:01 pm

thanks for the replies..