Solved

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

Posted on 2011-03-23
2
847 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

832 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