Working with commit and rollback statements
Stored procedures with commit and rollback statements don't seem to work if they are created from Operations Navigator or STRSQL. The only way I can get it to work is to use the "RUNSQLSTM" with the "COMMIT(*CHG)" option. How can I get it work from Operations Navigator or STRSQL?
RUNSQLSTM SRCFILE(TEST/QTXTSRC) SRCMBR(COMMITALL) COMMIT(*CHG) NAMING(*SQL) ERRLVL(10) DFTRDBCOL(TESTCOL) CLOSQLCSR(*ENDMOD) DBGVIEW(*LIST) OUTPUT(*PRINT)
You need to embed a SET OPTION COMMIT=*CHG clause into the stored procedure source.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this Search400.com Featured Topic: Database issues resolved