Hi ,
I am new to DB2 . Can anyone please let me know how to create teamporary table with in a stored procedure and running a while loop on the temporary table.

Thanks,
Vijay

if you are new, the first thing todo is to find the doc
Declaring global temporary tables
and read some chapters..

If you are 9.7 , CGTT is an option too

CREATE GLOBAL TEMPORARY TABLE - IBM DB2 9.7 for Linux, UNIX, and Windows
-

In my experience,
many of temporary tables were unnecessary.
(One of exceptional patterns may be sharing the temporary table(s) in multiple procedures.)

I thought same things in your procedure, especially if the process in the while loop was not so complex.

Thank you all.Its very useful