rsor | Reusable slice of references

Your syntax is not valid.

You must declare your temporary table independently of your cursor.

You cannot combine these in a single statement.

Use dynamic-SQL features to achieve what you need.

Use instead the format:

Declare c1 cursor with return to caller for Statement1

and

set v_cursor_text = 'select ... from session.temp ; `

then use

prepare Statement1 from v_cursor_text;

and before you exit the stored procedure you need to leave the cursor opened:

open c1;

Do study the Db2 online documentation to learn more about these features.

Here is a small fragment of your procedure showing what I mean: