Srini

SQL Delete Top Examples Explained

The best SQL query you can use while deleting a row from a table. The example SQL is simple to use and understand,so this a piece of code readily you can use in projects.

4 Types of DB2 Time Formats

The different time formats in DB2 really a good idea to know all these format. When you are working on international projects knowing time formats is really a worth.

DB2 SQL Global Temporary Tables top Usage

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

Join Vs Sub-query Top Differences to Read Today

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.

How to Create UDF in DB2

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.

COBOL Strings, Here are Ideas (1 of 2)

Best COBOL string real project examples like INSPECT and converting. Read more.

COBOL: Move, Group Move, Low-values, High-values

These tips in COBOL Move, Group Move, Low Values and High values highly helpful to COBOL developers working in Mainframe projects.

11 Qualities You Need for DBA Job

The very common roles of DBA in managing databases across the IT projects. Read more.

Legacy Applications: These are Top Methods to re-engineer

The re-engineering of mainframe apps is hot in the market. Benefits and the reasons to go for it explained in this post.

DB2 v10 Changes for Timestamp

The DB2 timestamp format example and the new changes made in DB2 v10. Read more.

DB2 V10 New Features to Read now

DB2 version 10 new features that have been added. A quick guide for DB2 developers.

DB2 Tutorial For Software Developers (1 of 5)

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.