How i can put a result set from a stored procedure

Question

The title is very descriptive i think... My scenario is the next. I need to put the result of a result set (for example a result set with 6 columns and variable rows) from a stored procedure in some temporary table to make some operations over this new table. I find some examples in the web but nothing in DB2... The big problem is how to populate that new table with the restult set of a called stored procedure

Answer 1

DECLARE GLOBAL TEMPORARY TABLE probably accomplishes what you want. You can create this type of temporary table inside a stored procedure. It is visible only to the current session and is cleaned up for you when the session ends.