The ALTER PROCEDURE (External) statement alters a procedure at the current server.
Modify the definition for an external procedure so that SQL changes are committed on return from the procedure.
ALTER PROCEDURE UPDATE_SALARY_1 ALTER COMMIT ON RETURN YES
For more information, see ALTER PROCEDURE (External) in the SQL Reference topic in the Information Center.