ALTER PROCEDURE (External)

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

Examples:

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