How to RollBack the SQL Querries in XMII

[Former Member]

Hi,

I need to Rollback the SQL query for the parent table if the query for the child table fails in the transaction.

In the current scenario I have two separate table one is the parent table for which I have a ID column referred by the child table.

However,if the query for the child table fails I need to rollback the parent table query.

Is there any way to do this in MII?

Thanks

Amit

[abesh · Accepted solution]

Amit,

To answer your questions in a single line, there is no MII capability that lets you do this inherently from MII. However there are two alternatives.

1) As Manoj mentions is to use Stored Procedures.

2) Use JTA Action Blocks. [Read about them and download them here...|http://www.google.com/url?sa=t&source=web&cd=2&ved=0CB0QFjAB&url=http%3A%2F%2Fwww.sdn.sap.com%2Firj%2Fscn%2Fgo%2Fportal%2Fprtroot%2Fdocs%2Flibrary%2Fuuid%2F10bfa608-103b-2c10-6399-e41044c3363e%3Foverridelayout%3Dtrue&rct=j&q=sap%20mii%20jta%20action&ei=0iXLTPDRCoTsuAOayqj_Dw&usg=AFQjCNHetW1FIkRNnuMypaZyM9XDVhgc9Q&sig2=bM660sTZXBk95LfF_scBEg&cad=rja]

You should however note that the JTA Actions blocks are provided as is, with no official support from SAP and I would be very brave indeed to use them in a production environment.

Abesh

[Former Member]

Hi Amit,

I have done rollback in MII through Storred Procedure.

you can write storred procedure in your SQL Server than execute same from SQL Query in MII.

Hope this help

Regards,

Manoj Bilthare