beautypg.com

Delete a jar file, Create a procedure, Delete a jar file create a procedure – HP Neoview Release 2.5 Software User Manual

Page 165

background image

NOTE:

You can rename only one JAR file at a time.

TIP:

To select a row, click the File Size value rather than the File Name. If you click the

File Name

, HPDM changes the display to provide detailed information about the selected

JAR file.

5.

Click Rename. A Confirm dialog box asks you to confirm the Rename operation.

6.

Click Yes to continue. Otherwise, click No to end the operation.

7.

When you are done, click File > Exit or the Close button ([ X ]) to close the Procedure Code
File Tool

dialog box and return to the HPDM main window.

Delete a JAR File

This procedure deletes one or more JAR files on the Neoview platform

CAUTION:

Deleting a JAR file might leave a dangling stored procedure reference in the Neoview

database. A dangling reference might cause errors when an application tries to execute the stored
procedure. To prevent dangling references, drop the stored procedure from the database before
deleting the JAR file. For information about dropping a stored procedure, see

“Drop a Procedure”

(page 169)

.

To delete a JAR file:

1.

In HPDM, select the Database area. For more information, see

“Select an Area” (page 35)

.

2.

In the navigation tree pane, right-click a schema name, and select Procedure Code File
Tool

. The Procedure Code File Tool window appears.

3.

In the left pane of the Procedure Code Files Tool, open the folder for your Neoview role or
user ID to display the JAR files within it.

NOTE:

If you selected the folder for your role, note that the Procedure Code File Tool

shows all of the JAR files for the Neoview role that you used to connect to the current system.
The role is your default role unless you specified a different role in the system definition.

4.

Select the JAR file(s) that you want to delete.

TIP:

To select a row, click the File Size value rather than the File Name. If you click the

File Name

, HPDM changes the display to provide detailed information about the selected

JAR file.

5.

Click Delete. A Warning dialog box asks you to confirm the Delete operation.

6.

Click Yes to continue. Otherwise, click No to end the operation.

7.

When you are done, click File > Exit or the Close button (

) to close the Procedure Code

File Tool

dialog box and return to the HPDM main window.

Create a Procedure

Create Procedure

registers an existing Java method as a stored procedure in Java (SPJ) within

Neoview SQL.

NOTE:

HPDM creates procedures with default privileges only. For more information about

privileges for SPJs, see the Neoview Guide to Stored Procedures in Java.

Requirements:

Delete a JAR File

165