By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

warning message along with result set

P: n/a
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

Oct 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.