When you exchange XML documents between different systems or applications, you may need a construct that ensures your applications will “understand” the XML documents that are being exchanged. And this is where XML schema comes into a play!
A singleton SELECT - is this always the best solution for readability and performance? The article discusses a simple scenario, that shows that a singleton SELECT can result in surprising application behavior if not used properly.
Let's spend some time in this post with the pureXML storage concept, discussing how DB2 stores XML documents in the database. You may think this is too theoretical; that it is something happening in the background that you don’t need to know. But give it a try!
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 Emil Kotrc
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