Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to use Temporary tables with Cursors ?
Hi All, I'm new to DB2 stored procedures. I'm trying to create a temporary table, then select data into it from number of different tables, than return result as a ResultSet into Java application. Here is the procedure, it's jut a draft. But it doesn't compile. Without Declare temporary table...
