(Henrik Loeser) Last week I wanted to start testing some new Db2 features without going through the steps of installing that Db2 version.

(Paul Tuohy) One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.

(Marie Sumabat and Jennie Chang) With the activation of function level 504, Db2 12 for z/OS introduces support for the following 16 built-in functions, which can be invoked when using IBM Db2 Analytics Accelerator (Accelerator):

(Ember Crooks) 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.

(Damir Wilder) Have you ever had a need to quickly find out if a DB2 table has any dependencies, i.e. foreign key relationships to it and from it?

(Martin) 94% of our studio audience learned something!Neal described the issues, challenges and techniques for designing optimal batch applications.

(Ember Crooks) This statement is actually a delete. It cascades to at least 300 other tables in a WebSphere Commerce database.

(Scott Vetter, Ivaylo B. Bozhinov, Anto A John, Rafael Freitas de Lima, Ahmed.(Mash) Mashhour, James Van Oosten, Fernando Vermelho, and Allison White) As big data becomes more ubiquitous, businesses are wondering how they can best leverage it to gain insight into their most important business questi

(Ember Crooks) This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance.

(Paul McWilliams) We’re proud to announce Db2 12 function level 504!