hi,
i'm trying to return a result set from a procedure using i series
navigator.
how ever i am getting the results back but with warning as below.
Message: [SQL0466] 1 result sets are available from procedure
GET_PROC_2 in T1. Cause . . . . . : Procedure GET_PROC_2 in T1 was
called and has returned one or more result sets. Recovery . . . :
None.
SQL State: 01S02
Vendor Code: -99999
Message: Option value changed.
Statement ran successfully, with warnings (1609 ms)
but i am returning only one result set (i have send my procedure body).
what could be the reason for this is am wrong anywhere..
appreciate u'r help
ET PATH "QSYS","QSYS2","U0002505" ;
CREATE PROCEDURE T1.GET_PROC ( )
DYNAMIC RESULT SETS 1
LANGUAGE SQL
SPECIFIC T1.GET_PROC
NOT DETERMINISTIC
READS SQL DATA
CALLED ON NULL INPUT
SET OPTION ALWBLK = *ALLREAD , ALWCPYDTA = *OPTIMIZE , COMMIT =
*NONE , DECRESULT = (31, 31, 00) , DFTRDBCOL = *NONE , DYNDFTCOL
= *NO , DYNUSRPRF = *USER , SRTSEQ = *HEX
P1 : BEGIN
DECLARE V_QUERY VARCHAR ( 6000 ) ;
DECLARE CUR_APP_QUERY CURSOR WITH RETURN TO CLIENT FOR STMT ;
SET V_QUERY = ' SELECT COL_1 FROM T1.TEMP_1' ;
PREPARE STMT FROM V_QUERY ;
OPEN CUR_APP_QUERY ;
END P1
thanks
sridhar