(Ritesh_Singh) This is about connecting/accessing DB2 database through C++ code using DB2 call level interface. An application that uses an embedded SQL interface requires a precompiler to convert the SQL statements into code, which is then compiled, bound to the database, and executed.

(Marion Behnen and Kiran Kumar) IBM DB2 Text Search enables users to create full-text indices in a DB2 for Linux, UNIX, and Windows database. Full-text indices are updated asynchronously, and it is necessary to explicitly and regularly start text index updates to ensure that an index properly reflec

(Troy Coleman) Recently someone on the DB2-L list serve asked if there’s a way to return all the detail rows along with a summary row in a single SQL statement.

(Henrik Loeser) Yesterday I received an interesting question regarding licensed features in DB2 and how the license is enforced. Someone was able to create an MQT even though the DB2 edition does not include support for it. But why? I try to explain.

(Marty Lurie) This article is focused on explaining Big Data and then providing simple worked examples in Hadoop, the major open-source player in the Big Data space. You’ll be happy to hear that Hadoop is NOT a replacement for Informix or DB2, but in fact plays nicely with the existing infrastructur

(Robert Catterall) If your answer to the question posed in the title of this blog entry is, “In a PORT reservation statement in our z/OS LPAR’s TCP/IP profile data set,” that’s NOT what I want to hear. It’s true that for a long time this was the standard way to assign an IP address to a DB2 for z/OS

(Whei-Jen Chen, Pat Bates, Tim Donovan, Garrett Fitzsimons, Jon Lind and Rogério Silva) IBM InfoSphere Warehouse is the IBM flagship data warehouse platform for departmental data marts and enterprise data warehouses. It offers leading architecture, performance, backup, and recovery tools that help i

(Julia Canella and Eugene Kharlamov) WebSphere Message Broker V8 (hereafter called “Message Broker”) Toolkit Fix Pack 1 makes your message flows more flexible by enabling you to update and deploy parts of a flow without recompiling and redeploying the entire flow. You can also assemble your broker a

(Serge Rielau) When our team added compatibility for DB2 with Oracle applications we learned that no two functions were compatible between Oracle and DB2 as far as date-time arithmetic was concerned.

(Willie Favero) An informational APAR was recently opened that’s list DB2 9 new function mode (NFM) and DB2 10 NFM fixes for DSNTEP2, DSNTEP4, DSNTIAUL, and DSNTIAD. It currently list over a dozen fixes. If you are a frequent user of these DB2 supplied productivity-aid sample programs, You need