Stored Procedure Drop

You can drop a stored procedure.
carcudb2
You can drop a stored procedure.
When you perform a drop of a native SQL stored procedure, you can drop all versions, or you can view and drop specific versions.
Follow these steps:
  1. Complete fields as follows on the CA RC/Update Main Menu:
    • Type
      D
      in the Option field.
    • Type
      PR
      in the Object field.
    • (Optional) Type a name in the Item Name field.
    • (Optional) Type values for one or more of the remaining fields. For complete information about the fields on the CA RC/Update Main Menu, see the online help. You can also generate drops from the CA RC/Update Drop panel or any create, alter, or template panel.
    The CA RC/Update Drop Procedure Selection panel appears, from which you can select one or more objects to drop.
  2. (Optional) Perform one of the following to display versions for native SQL procedures in your list:
    • Enter
      VERSIONS
      in the command line to display versions of any native SQL procedures.
    • Enter
      V
      next to a specific native SQL procedure to expand its list of versions.
    Additional versions are listed separately.
  3. Enter one of the following commands next to each procedure that you want to delete:
    • S
      – Specifies to perform a standard drop without options.
    • SO 
      – Specifies to perform a standard drop with options. The product displays a Drop Options panel for each object selected with SO.
    • – Specifies to perform a recoverable drop. This type of drop saves recovery information so that the object can be recovered and restored to its original state at a later time.
    • RO 
       
      Specifies to perform a recoverable drop with options. The product displays a Drop Recovery Options panel for each object selected with RO.
    If you have specific versions under a native SQL stored procedure, you can then select the specific versions that you want to drop.
    If you requested deletion for a native SQL Stored procedure with multiple versions, the Drop All Versions Confirmation window appears.
  4. Enter a value in the Drop All Versions Confirmation window to determine whether to delete all versions:
    •  
      Drops all versions of the selected native SQL stored procedure. A DROP PROCEDURE statement will be generated for the drop.
    • – Does not drop any versions for the selected item, bypassing the selection in its entirety. This is the default.
    The CA RC/Update Drop Impact List panel appears, listing the objects that will be dropped, based on your request.