MQSeries.net :: View topic - Deleting set of records from list without looping in WMB

touchofcrypticthunder · Posted: Mon Feb 11, 2013 9:13 am Post subject:

I am looking for a solution to delete set of records matching slection criteria from a large list without looping through the list. This is something similar to "DELETE FROM TABLE WHERE(<matching condition>)" SQL statement.

The actual scenario is, we have big list of records from backend service which have parent child relationship based on an element say "ParentId" in the records. I loop through the list and use SELECT statement on this list to fetch the related records and process them. Then I will create separate message by grouping the records having the same ParentId. I will keep track of ParentId's processed so that the records having the same ParentId is not processed again. Another thing to note here is, records having the same ParentId can appear anywhere in the list which need not be sequential.

To have good response time, I thought it would be better to delete the records processed using SELECT statement so that list becomes smaller and smaller and processing time would become more efficient.

I did not find a simpler way to delete the processed records without looping and hence posting this in this forum. Please let me know if there is a way in ESQL to delete set of records without looping and which simulates SQL DELETE statement.