Tweet
Recent V5R2 PTFs support the return of result sets from nested stored procedures. This statement, from Registered Knowledge Base document 19693746, is no longer true: "When an application uses nested stored procedure calls (a stored procedure that calls a stored procedure), any result set returned to the client must originate from the bottom-most level (the stored procedure called by the client). This is the only environment currently supported. There is no method to work with a stored procedure result set in a procedure or to pass the open cursor returned from a nested call back to the caller. If a stored procedure calls another stored procedure that returns a result set, unpredictable results may occur." The PTFs are SI13616,SI13309, SI13265, SI13264, SI13262, SI13261, SI13260. They are likely to be included in DB2 Group PTF 13, due out any day now. The RETURN syntax is below.
Code
Code