Best example SQL query to create Global temporary table in DB2. This is temporary table applicable to current session. It is like scratch pad table also called an intermediate table
In DB2 Joins and Sub-queries are two different concepts frequently used in writing SQL queries. These absolutely know differences help you write SQL queries in much better way ,which give an excellent performance.
There are 5 different functions can be created in DB2 as part of user defined functions (UDF). Out of which three functions that can be created using only SQL statements.
The very common roles of DBA in managing databases across the IT projects. Read more.
The DB2 timestamp format example and the new changes made in DB2 v10. Read more.
DB2 version 10 new features that have been added. A quick guide for DB2 developers.