How to send bad records on the fly to a file

Hi,
I want to send bad records to a file with the name of the source file, no of source record,primary key.
reply ASAP.

with regards
murali

are you loading data from any source to database ?

[QUOTE=debasisdas;22822]are you loading data from any source to database ?[/QUOTE]

my source is mainframe

[QUOTE=vmrlgi;22849]
Hi,
I want to send bad records to a file with the name of the source file, no of source record,primary key.
reply ASAP.
-------------------------------
my source is mainframe[/QUOTE]

Dear Murali,

As per above info, you are having mainframe source loading into a relational table.

Can you implement Expression(which creates flag for duplicate records), then Router (to route the flagged/duplicate records) to fix the above problem...

Get to me if doesnot satisfies you...... ~~~~~~~~~