Originally posted by: SystemAdmin

I have a map with two output cards. The first output card inserting data in to database and the second card calling another map with RUN function with following syntax
VALID(RUN("MapB"), FAIL("Failed")

The problem is when the MapB fails the data inserted from the first output card is not rolling back. I have the scope set to "Map" in both the output cards and we are using Mercator 6.5.

Anyone experienced this problem before?

Thanks
Venkat
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

check setting for run map:
you have to set: Input card setting
Under source-> transaction -> OnFailure : Rollback
If you are not abule to fix this problem send maps and type trees as a zip file to rami_edi@yahoo.com
good luck
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks for your response. I have that setting already in all the input and output cards. It still doesn't work. I have a workaround for that, whenever child map fails I am rolling back the records from database. I think it is an existing problem that is what I found in all the forums.

Did you implement this kind of functionality before?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender