Continuing our example from the previous section, you can run procedure PROCEDURE1. Before a procedure can run, it must first successfully build on the database. Table D.3 contains the icons related to running procedures.
PROCEDURE1 is fairly simple. It executes the following SQL statement:
SELECT PROCSCHEMA, PROCNAME FROM SYSCAT.PROCEDURES;
The resulting rows are returned to the application as a result set (the Development Center, in this case), where the rows in the cursor are fetched.
Select PROCEDURE1 and click the Run button. The Development Center detects that a cursor has been returned and automatically fetches rows back from it.
You will be able to see the rows fetched back in the Results tab of the Output view, as shown in Figure D.22.
Figure D.22. Viewing data returned by cursors in the Development Center.
If you are running a function or a procedure with OUT parameters, the results will appear in the Parameters tab of the Output view (see Figure D.23). PROCEDURE1 does not have any parameters. Therefore, no values are listed here.
Figure D.23. Viewing input and output parameter values in the Development Center.