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
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.