Autocommit behavior for DB2 stored proc called from informatica powercenter

Question

I have a stored procedure being called from an informatica mapping. There are no manual commits inside the procedure and the procedure is created with 'COMMIT ON RETURN NO'

I can see the updates done inside the procedure being committed. I think this could be because of the auto commit setting in the Informatica Server. (And I assume the 'commit after end of file' option in the task properties does not apply to stored proc calls)

If this is the case,assuming I do not want to commit anything even if procedure completes without errors, where do I find the autocommit setting (BD2 Driver configuration/Informatica configuration) and change it?

Answer 1

The default setting is present in the workflow session settings under properties tab