Using commit command in database stored procedure called from APPIAN

Hello,

Environment used: APPIAN 17.1 with a IBM DB2 database attached to it.  

At the start of my application I use the Execute Stored Procedure Smart Service to call a stored procedure that collects that from multiple cdt tables, but also non cdt tables that are populated from an external source. In that procedure I also use temporary tables and different commands: merge, insert, update. 

Are there any restrictions in using multiple  commit commands in that procedure? Does the smart service commit after all the transactions or how does the smart service work?

Also, if there are any best practices that you can share with me, it will be highly apreciated.

Thanks in advance,

George

 

  Discussion posts and replies are publicly visible