ChannelDB2 is a social network for the DB2 community. It features content such as DB2 related videos, podcasts, blogs, photos, resources, etc. for Linux, UNIX, Windows, System z, and System i.
Take Free BLU Acceleration Mini Course
BLU Acceleration technology in IBM DB2 is hot! Why? It's easy to implement and use. And, it's extremely fast.
Learn about its key technologies: bit.ly/miniblucourse
I have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process.
After repeatedly receiving errors on a statement I was trying to execute – both from Jupyter Notebook and from the command line using dbaccess, I was absolutely flabbergasted to learn that INFORMIX DOES NOT SUPPORT CTEs.… Read the rest
This statement is actually a delete. It cascades to at least 300 other tables in a WebSphere Commerce database. The original query here was the default syntax supplied by IBM with WebSphere Commerce back with WCS 6. I’m not sure if it survives in this form in WCS 7 or 8, but the modification here has become one of my go-to things to look for in problem queries that aren’t helped by easily identifiable indexes.… Read the rest
Whether you think about it an in-home escape out of your hectic day or just someplace to clean up, the lavatory is one place in your house everybody is bound to go to. Taking advantage of a small house is […]