How to learn more about DB2? The answer is simple: DB2 Express-C, the community edition of DB2. You can learn, experiment and develop queries and applications through this easy to use and install version of DB2.
A short story about SQLCODE -420 and implicit data conversions
Do you know those minor changes in your code that cannot break anything, but, well, actually they do? I had such experience recently. I did a very minor update to a WHERE clause of a SELECT statement in an embedded SQL, but t
Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This pres
Today we will discuss how LOAD and UNLOAD utilities and file reference variables can help you to overcome inefficiencies in XML document maintenance with standard SQL statements.
There has been quite a bit of attention paid to the access path stability features of DB2 for z/OS since they first appeared in DB2 9. Enhancements have followed in each subsequent release. This article will discuss these features.