DB2 graphic  QMF Version 8

Running a stored procedure that returns a result set

Stored procedure USERA.RET1RS has two output parameters. The first, defined as an integer, returns the SQLCODE. The second, defined as a character string, returns the SQLSTATE. This stored procedure also returns a result set based on the following SELECT statement from the QMF supplied table Q.STAFF:

SELECT ID, NAME, DEPT, JOB, YEARS, SALARY, COMM FROM Q.STAFF

Verify that QMF global variable DSQEC_SP_RS_NUM is set to one. Issue the CALL statement on the SQL QUERY panel:

CALL USERA.RET1RS(&A01, &A02)

Upon completion, you will see this message:

OK, Your Stored Procedure has successfully completed.

Your result set is displayed; you can page forward or back to view the entire report.

Figure 182. Result set from USERA.RET1RS
 REPORT                         LINE 1    POS 1     79
 

     ID  NAME      DEPT  JOB   YEARS    SALARY        COMM
   ----  --------- ----  ----- -----     --------  -------
     10  SANDERS     20  MGR       7    99999.99         -
     20  PERNAL      20  SALES     8    18171.25    612.45
     30  MARENGHI    38  MGR       5    17506.75         -
     40  O'BRIEN     38  SALES     6    18006.00    846.55
     50  HANES       15  MGR      10    20659.80         -
     60  QUIGLEY     38  SALES     -    16808.30    650.25
     70  ROTHMAN     15  SALES     7    16502.83   1152.00
     80  JAMES       20  CLERK     -    13504.60    128.20
     90  KOONITZ     42  SALES     6    18001.75   1386.70
    100  PLOTZ       42  MGR       7    18352.80         -
    110  NGAN        15  CLERK     5    12508.20    206.60
    120  NAUGHTON    38  CLERK     -    12954.75    180.00
    130  YAMAGUCHI   42  CLERK     6    10505.90     75.60
    140  FRAYE       51  MGR       6    21150.00         -

 1=Help    2=     3=End     4=Print     5=Chart    6=Query
 7=Backward   8=Forward   9=Form   10=Left   11=Right  12=  
 OK, this is the REPORT from your RUN command
 COMMAND ===> 
 

You can view the output parameters in the global variable pool by using the SHOW GLOBALS command.


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