Updating a stored procedure
You can use the BMC AMI Command Center Alter editor to update and test native stored procedures. The Alter editor Procedure tab displays the procedure's code.
Before you begin
To make these changes, you must have the required Db2 privileges.
To update a stored procedure
- In the DB2 Navigator perspective, select a native stored procedure.For more information, see Navigating-to-an-object.
On the Tasks toolbar, click Alter
.An Alter editor view is displayed in the Schema Management perspective.
- To invoke the stored procedure, click CALL
. Otherwise, proceed to step 6. In the Parameters dialog box, complete the following fields and click OK:
Field
Description
Commit
Select Commit or Rollback.
Parameters Profile
Select a saved set of values to use as Input Parameters
Input parameters
Enter data for each of the parameters listed
Save
To save the input parameters as a profile, click Save, enter a name for the profile, and click OK
The Output tab displays a summary of the stored procedure.
To view results for a specific command, click the relevant View result set.
Tip
If the procedure fails to run successfully, click View Messages
to see all error messages, or click on the Output tab to view error messages for a specific command.- Make any needed changes to the parameters, editable options, and procedure.
- To test your changes, click CALL .
In the Parameters dialog box, complete the following fields and click OK:
Field
Description
Execute the Alter statement before calling the procedure
Select this field to generate and run an ALTER statement for the changes.
Commit
Select Commit or Rollback.
Parameters Profile
Select a saved set of values to use as Input Parameters.
Input parameters
Enter data for each of the parameters listed.
Save
To save the input parameters as a profile, click Save, enter a name for the profile, and click OK.
The Output tab displays a summary of the stored procedure.
- To make additional updates, click Refresh alter editor
and then return to step 6.