Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013

    Unanswered: Describe Procedure Command in DB2 UDB 9.7

    Hi All,

    I am using DB2 UDB v9.7. I am working on handling result sets inside a stored procedure (A) which is calling stored procedure (B).
    I want to know the number of result sets returned by the called stored procedure (B).

    I tried command - DESCRIBE PROCEDURE B but it's not working. Also I am not sure how to store (either in SQLDA or SQL Descriptor) the result returned by this command.

    Would appreciate if someone share some information on this.

    Many Thanks in advance!


  2. #2
    Join Date
    Apr 2012
    Provided Answers: 25
    It is useless to write "it's not working" unless you specify the exact command/statement and the exact result.

    DB2 v9.7 on LUW does not have a "describe procedure" statement.

    For catalogued SQL and java sprocs, you might check syscat.routines column RESULT_SETS (although the docs state it is an estimate of the max #result-sets)

Posting Permissions

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