Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.
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.
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.
The very simple way you can do DATE and TIME calculations in DB2. You can use these examples in your SQL instantly. Also, you can get DATE and TIME from your Timestamp. Read more.
In DB2 Date , time and timestamp are three different columns in a table. So this post gives the best idea on how to choose these columns in Table to suit project requirements as well as better performance.
We know that stored procedure can be called from either COBOL /PLI programs. Once you…
The best syntax for EXPLAIN PLAN -EXPLAIN——————————————————> >–+-+-PLAN-+–+———————+–FOR–explainable-sql-statement-+->< | ‘-ALL–‘ ‘-SET QUERYNO=integer-‘ | +-STMTCACHE–+-ALL——————————–+—————–+ |…