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.