Originally posted by: SystemAdmin

Hi,

Please find my scenario flow as given below

1. There is one input card configured to the database table, BaplieDBTable. And two output cards, one to Flatfile and another to the database table, BaplieDBArchive.
2. The first o/p card creates an EDIFACT message from the data in the BaplieDBTable.
3. The second o/p card transfers the data from BaplieDBTable to an archive table BaplieDBArchive.
4. After the entire transaction completes 'Succesfully', I would like to remove/delete the records from the BaplieDBTable.

I am stuck over the deletion part. I could not find it in the card settings.

Thanks in advance.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: raj1

The OnSuccess option for a source or target is not supported in WTX. SQL delete statements and stored procedures used as sources can be used for deletion purposes.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Outside of WTX, you could consider a database trigger (On insert of BaplieDBArchive, delete from BaplieDBTable where...)
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

Use DBLOOKUP in an output card with the SQL statement to delete the records.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks everyone.
I was hoping I missed something in the card settings.
Do you think there is a fix or something of the sort, because, deleting the records after the transaction is complete is different from adding another card and deleting the records. As an afterthought, it appears like it does not make much of a difference.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

There's no fix as there's nothing broken. If you read the data from the database and delete it as part of the same query, then if your map fails you would have to roll it back any way. This is no different from deleting it as the last phase of the map when you know everything was successful.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: janhess

If you want to process 1 row at a time use burst mode on the input card with a fetch unit of 1 or pass the row to another map that does the processing.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange