Can you use temp tables in db2 udb sql stored procedure?

Posted on 2011-03-23
Medium Priority
Last Modified: 2012-05-11

We've just switched to DB2 UDB from SQL Server and are trying to convert our SQL stored procedures to run on DB2. I'm using IBM Data Studio to create the stored procedures.

Some of our sql stored procedures use temp tables but i can't seem to create these in the ibm data studio. Is it possible to use temp tables in DB2 UDB/IBM Data studio and if so, what is the code to create them?

Question by:smythsit
LVL 37

Accepted Solution

momi_sabag earned 2000 total points
ID: 35197446
sure it is possible
just use
declare temporary table

i would also go through this book
it will help you

also take a look here

Author Comment

ID: 35197482
Great thanks

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question