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…
Load utility in DB2 useful to load massive records. Give here key concepts for quick reference.
Row is one kind of data type in DB2. This post covers the benefits of row id data type.
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.