Solved

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

Posted on 2011-03-23
2
839 Views
Last Modified: 2012-05-11
Hi,

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?

Thanks
0
Comment
Question by:smythsit
2 Comments
 
LVL 37

Accepted Solution

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

i would also go through this book
it will help you
http://www.redbooks.ibm.com/abstracts/sg246672.html

also take a look here
http://www.ibm.com/developerworks/data/downloads/migration/mtk/
0
 

Author Comment

by:smythsit
ID: 35197482
Great thanks
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now