SQL queries to convert DB2 date format using to_char and to_date functions. Also, given how to get the current date and time.
DB2 performance improvements in Utilities you can find in detail here. These are useful for your projects.
In DB2, the dynamic indexes concept is a frequently asked question. Here is complete information on how DB2 will create those.
Here explained how DB2 CHAR and VARCHAR stores strings. It’s helpful to understand the differences between these two.
Check and Default constraints are both not the same. They create during create Table. Differences between these you can understand with these examples.
Here is a resolution for SQL error -206. You will get an error of object is not valid. Here are possible reasons for this error. Also given solution for how to fix it.
How to use package in DB2, and its real benefits explained to use in your programs.
Here is the top B-Tree index mechanism that followed in DB2. It is a helpful explanation for DB2 developers.
Here’s a way you can use to check DB2 utility job completion status in mainframe Z/Os.
DB2 SQL query performance tuning ideas. Here’re the ways that you can use.
In DB2, you need to know Rusnstats utility when it has to run. Ideas that are given in this post help you to make a decision.
SQL procedure saves your time when writing it for repetitive tasks. On top of that, writing code with Labels improves readability. So that maintenance is easy.