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