DB2 graphic  QMF Version 8

Running a stored procedure that returns no output parameters

To run a stored procedure with no parameters, enter the CALL statement on the SQL QUERY panel. The stored procedure used in this example performs some DB2 maintenance functions. You can set up your stored procedure to do maintenance functions required at your site. Issue the CALL statement on the SQL QUERY panel:

CALL USERA.MYPROC1

Upon completion, you will see this message:

OK, Your Stored Procedure has successfully completed.

Verify that the maintenance functions provided by your stored procedure were performed.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004