Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    123

    Unanswered: Error calling sproc

    Hi,

    I'm trying to call a db2 stored procedure using jdbc and keep getting this error, any idea how I can fix this? thanks!

    SQL0464W Procedure "<proc>" returned "<num>" query result sets, which exceeds the defined limit "<integer>".

    Explanation: The stored procedure named by proc completed normally. However, the stored procedure exceeded the defined limit on the number of query result sets the procedure can return.

    num
    identifies the number of query result sets returned by the stored procedure.
    integer
    identifies the defined limit on the number of query result sets for the stored procedure.

    Only the first integer query result sets are returned to the SQL program that issued the SQL CALL statement.

    The possible causes are as follows: The stored procedure is unable to return num result sets due to the DRDA limitations imposed by the client. The DRDA client establishes this limit with the MAXRSLCNT DDM code point.

    User Response: The SQL statement is successful. The SQLWARN9 field is set to 'Z'.

    sqlcode: +464

    sqlstate: 0100E

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    This is not an error, it is just a warning.

    To resolve this issue, you should make sure that the procedure doesn't return more result sets than the indicated limit allows. Maybe you simply don't clean up in the procedure, i.e. don't close all cursors that should not be returned as result set?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •