Index is popular object in DB2 SQL. Popular questions to your instant knowledge given for quick reference.
All you need to know about Cursor the real use and how it works on commit or Rollback scenarios. Really useful information for SQL professionals.
Table in SQL is the very first step to understand it and how to create it. The tips are highly useful to learners.
Reorganisation in DB2 is many times a usable utility. When you want to do loading or unloading there you may face many different errors. So this is one of the main solution to reorganise the table space.
DB2 Load utility with example and explained the key phrases. These are really good to have knowledge before you start working on it.
You all know RENAME clause in SQL is highly useful to change the name of Table, Index or other objects. Given here why this clause is used and syntax and Rules presented for ORACLE and DB2 databases.