Replacing a Stored Procedure Definition

You can replace the SQL definition of a stored procedure and change whether the procedure is recompiled each time it is executed.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Procedures > Stored Procedures.
  2. Choose one of the following:
    • Click the drop-down arrow on the stored procedure for which you want to replace the definition and select Replace.
    • From Stored Procedures in the left pane, click the drop-down arrow and select New. Enter the name of the existing stored procedure for which you want to replace the definition.

      When selecting an existing stored procedure, the Confirm Replace dialog appears with an option to replace the object definition or cancel the replacement.

    The Replace Stored Procedure wizard appears.
  3. (Optional) On the Compilation Option screen, change the recompiling setting for the procedure.
  4. (Optional) On the Execution Behavior screen, change the procedure execution behavior.
  5. (Optional) On the SQL Editor screen, enter any changes to the SQL description.
  6. (Optional) On the Summary screen, verify the stored procedure name, group, compilation option, database, and owner.