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.
One could say that we are almost at the end of our journey. The DB2 11 Application Developer for z/OS certification test consists of 10 sections so this writing should be the end of the story, right? Well, sort of.
First, thank you if you read these blogs, hopefully you found them interesting and