Solved

stored proc runs fine but gives a warning

Posted on 2007-03-26
2
1,746 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 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