Returning Mulitple Result Sets in DB2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • itsesoteric
    New Member
    • Nov 2015
    • 1

    Returning Mulitple Result Sets in DB2

    I have two procedures (P1 & P2). P1 returns 1 result set of Subscriber ID (and can be called standalone).

    P2 calls P1 to use the result set to create result set 2 (Subscriber Eligibility) and result set 3 (Subscriber profile). Retrieval of the two result 2 & 3 set is fine, but I don't know how to access result SET 1 for P1 to return to caller.
Working...