Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1884
  • Last Modified:

stored proc runs fine but gives a warning

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
Camillia
Asked:
Camillia
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
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
 
CamilliaAuthor Commented:

well, good. Thanks.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now