ALTER PROCEDURE (SQL)

The ALTER PROCEDURE (SQL) statement alters a procedure at the current server.

Examples:

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 CenterLink to Information center.