-925   COMMIT NOT VALID IN IMS, CICS OR RRSAF ENVIRONMENT

Explanation

An application executing in either an IMS™ or CICS® environment or an application executing in an RRSAF environment when DB2® is not the only resource manager has attempted to execute a COMMIT statement. The SQL COMMIT statement cannot be executed in these environments.

System action

The statement cannot be processed. No commit is performed.

Programmer response

The IMS, CICS or RRS protocols should be used to commit work in these environments.

If a stored procedure is being called from IMS or CICS, ensure that the stored procedure is not defined to perform a commit on return.

SQLSTATE

2D521