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