Neoview Guide to Stored Procedures in Java (R2.5)

all objects, members of your role could drop procedures. For more information about the GRANT
SCHEMA statement, see the Neoview SQL Reference Manual.
To drop a procedure:
1. Under the navigation tree pane, click the Database area.
2. Under My Systems, expand the tree for the Neoview platform containing the procedure
until you can see the schema folder and the Procedures folder underneath it.
3. Expand the Procedures folder.
4. Right-click the name of the procedure that you want to drop, and select Drop Procedure.
HPDM asks you to confirm the operation.
5. Click [ Yes ] to continue or [ No ] to quit the operation.
Display Procedures and Their Properties
To display the SPJs in a schema, use either HPDM or NCI:
• “Using HPDM to Display Procedures in a Schema”
• “Using NCI to Display Procedures in a Schema” (page 44)
Using HPDM to Display Procedures in a Schema
To display the procedures in a schema:
1. Start the HP Database Manager and log on using any user ID.
2. Click the Database area.
3. In the navigation tree pane, select a Schema, and expand the schema so that you can see
the object folders underneath it.
4. Expand the Procedures folder, and select a procedure.
Display Procedures and Their Properties 41