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.
INSPECT Verb plays crucial role in string manipulation in COBOL. Best practical INSPECT VERB usages…
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.
Many projects in mainframe running online in dialog mode while others run in batch mode as background jobs. Many of these users would now like to migrate to a service-oriented architecture.
DB2 V10- Time stamp will have Date, Time and GMT+xx.xx This is a new change.…
The following features are added in DB2 V10: Improved scalability: DB2 10 substantially increases the amount…
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.