Unanswered: Describe Procedure Command in DB2 UDB 9.7
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.