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?
sure it is possible
declare temporary table
i would also go through this book
it will help you
also take a look here
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.
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…