Focal Point
[SOLVED] record logging accepted transactions

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8267070786

June 27, 2017, 06:16 AM
Martin vK
[SOLVED] record logging accepted transactions
Hi,

In my DM flow I have indicated I want record logging of the accepted transactions. I use this to make a summmary report of the processing that took place by making and emailing a report using the synonym/dataset of the accepted transactions.

This works fine generally, but I now bumped into an issue. When there are no records processed the dataset of accepted transactions of the previous run remains. I would expect it would result in an empty dataset. I did uncheck "Stop if 0 rows selected" so the flow does not give an error, but how do I arrange that the dataset of accepted transactions is empty?

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 7.7.06M/8.2.03M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
June 28, 2017, 08:12 AM
Clif
I would suggest writing a one line stored procedure to delete the accepted transactions file and add it to the process flow before the data flow.