Solved

stored proc runs fine but gives a warning

Posted on 2007-03-26
2
1,725 Views
Last Modified: 2008-01-09
This is related to the dynamic stored proc question i asked here;
http://www.experts-exchange.com/Database/DB2/Q_22472527.html?cid=239#a18793550

It works fine, i get results back but i also get this warning. The stored proc returns 1 or more rows. Should I be worried about it?

---
Return Code = 0


SQL State: 0100C
Vendor Code: 466
Message: [SQL0466] 1 result sets are available from procedure WSP_GETRESULTS in VQUEDTA020. Cause . . . . . :   Procedure WSP_GETRESULTS in <dbname> 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   (343 ms)

0
Comment
Question by:Camillia
2 Comments
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
ID: 18794628
Hello Farzadw,


There is absolutely nothing to worry about here.  :)

DB2 is simply returning a comment that a query in the stored procedure returned data.  If you want to access the data in that query, you can use WSP_GETRESULTS instead of reissuing a query against the user tables.



Kent
0
 
LVL 7

Author Comment

by:Camillia
ID: 18794642

well, good. Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now