Audit file should match Source file

[chandra]

Hi Frnds @
i hv one problem and looking for logic.
i get source file which contains actual data and another file is Aduit file. where i get summary of source file. like how many number of records and amount.
ex:- record count, amout->200,2500000.00
---------------------------
Source file should match -adut file.
other wise job should abort, this job i will use in seq.
I need ur best suggestion.whether i should write unix prog / it could be done in Datastage.
I tried with Compare stage but getting strange error that i hv posted earlier.No replay i got asusual.

Thanks

[chulett]

Be more specific - when do you want to do this validation? Before even attempting to load the source file to ensure you have a complete file or after you've loaded it to ensure all was loaded correctly?

I tried with Compare stage but getting strange error that i hv posted earlier.No replay i got asusual.

It would have helped if you had posted your question in the correct forum.

[chandra]

its a kick of job, not related to loading ..

job :-

match-->kick rest of job
else
Abort send a mail to team

[ag_ram]

Can After job subroutines be used to accomplish the same