Solved

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

Posted on 2011-03-23
2
835 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
Comment Utility
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
Comment Utility
Great thanks
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 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

12 Experts available now in Live!

Get 1:1 Help Now