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.
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.
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.