Solved

stored proc runs fine but gives a warning

Posted on 2007-03-26
2
1,805 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 45

Accepted Solution

by:
Kent Olsen 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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

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 (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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

691 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