Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.
Advertisements
Category: DB2
The DB2 split string function example really nice and you can use it in your project quickly.
In DB2 giving TIMESTAMP is very common and it is so important data type. I have given some popular points on it.
The best example for Java stored procedure in DB2, also given java class path to write stored procedure and explained how to include it in the DB2 stored procedure standard block. Read more.
How Db2audit plays crucial role in DB2 and what is the use of it. Really good stuff. Read more.
The 3 options in DB2 12 are going to be replaced by new functions. Read for more details.
The RPN Table space in DB2. What is new in it. How DB2 is handling big data. Read more.
IBM DB2 latest enhancement really suitable for analytics projects. These 4 best features you can find in DB2 analytics.
While working with DB2 utilities most of the time you will get different pending states. Due to this you cannot complete your task. This post well explained reasons why Check-pending state will come in DB2 and its resolution also explained.
The SELECT statement is a powerful and best SQL being used in all data warehousing projects. This SELECT statement contains 5 clauses. To master expert in writing SELECT query you need hands-on how to use these clauses.
