Dropping a stored procedure in Java

Prerequisites
To drop a stored procedure in java (SPJ) on a schema, log in as

  • The owner of the schema that contains the procedure.

  • The SUPER.SUPER user.

  • The owner of the SPJ.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, select Database > My Systems > Catalogs > Schemas.
  3. Expand the Procedures folder, right-click the SPJ you want to remove and select Drop Procedure.
  4. Select one of the following options:

    • Restrict to drop the procedure. The procedure is dropped only if it is not referenced by any other object.

    • Cascade to drop the procedure and any object dependent on the procedure.

  5. Click Yes.