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.
Best COBOL string real project examples like INSPECT and converting. Read more.
These tips in COBOL Move, Group Move, Low Values and High values highly helpful to COBOL developers working in Mainframe projects.
The very common roles of DBA in managing databases across the IT projects. Read more.
The short answer is that SOA is a business approach to building IT systems that allows businesses to existing systems. Mainframe is a legacy system to integrate current systems need SOA approach.
The re-engineering of mainframe apps is hot in the market. Benefits and the reasons to go for it explained in this post.
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.
A ready refresher and quick guide for developers. This DB2 tutorial covers CODDs rules , entity relation ships and 1st normal form to 5th normal form and more.
I wish you all great happiness this new year.