How to set ODBC autocommit off

[KathyW]

Does anyone know a way to set auto commit off for ODBCOutput? We are inserting data into a relational DB from a TI process, and by default ODBC is set to auto commit. We would like to commit only when the process is finished and all rows are inserted. I can't find any reference for how to do this in TM1.
Thank you for any help you can offer.

[tomok]

All you can do in TM1 is use an ODBC connection to issue a SQL command and receive data back, if called for by the SQL. You can't change any properties of the ODBC connection itself. That would have to be done in the Microsoft ODBC Data Source Administrator. Unless you can change this attribute via a SQL command (which you could issue to the server with an ODBCOutput command), there is no way to do it in TM1 itself.

[afshin]

Another way possibly you could do this is call a stored procedure using TI wherein you pass the measures, dimension as parameters and then issue the commit statement in the Epilog via another stored procedure.

I have never done this but I am sure this would work.