Knowing Primary Key on which column of Table it is defined is a tricky in mainframe zo/s DB2. This SQL query helps to find column name of table on which it is defined. Very useful query for mainframe developers working on DB2.
Many of the cases while working on real time projects you need to work with Excel. The tips tells how to find duplicates using Excel. Read more.
In DB2 by writing SELECT SQL query you will not get row numbers in your result. The example SQL query useful for your project to get row numbers in the result.
Mainframe programmers do not aware about there is checkpoints concept in DB2. Many guys assume that CHECKPOINT…
With Load utility you can insert rows, replace rows, and retain current rows in tables. If Db2 Load…
Row id in DB2 is Unique. This is one of the data type. Its value will be…
These are DB2 referential integrity and you always need to keep in mind while working with DB2 tables.
The best DB2 Load utility options that you need when you are working with DB2 projects. The methods given here always good to improve performane.
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.
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.