User-defined data types are like user-defined functions to create customized data types. UDD Type Example…
Tag: db2
Three most popular pending states in DB2. As a developer you may scare some times…
How to use count and count_big in SQL. Explained with examples and differences.
Cast function in SQL useful to covert one data-type to other,
The “COALESCE” function is one of the frequently used functions in DB2. Before going into…
CAST function rules to convert NULL value as an integer of Char.
In DB2 the status of copy pending will occur for many reasons. Mainly during UNLOAD/LOAD. Read my…
In this blog, you can find how to give an Array in WHERE clause of IN list. This way of using saves CPU time. Hence improve performance.