(Dave Beulke) Thank you all for the comments about last week’s blog. With the queries from last week you were able to see the various settings within your PLAN and PACKAGE environment and some were surprised with what they found.

(Kim May) The Fillmore Group will be hosting three sessions of what we are calling, gDB2 101 – sessions that provide an executive overview of the IBM Information Management product portfolio, one each month, in February, March and April.

(Patrick Titzler and Soid Quintero) IBM Optim Development Studio and the pureQuery Runtime include a command line utility called ManageRepository that can be used to create, modify, export, import, and delete pureQuery metadata that is stored in the SQL management repository.

(Troy Coleman) DB2 provides the facility to extend SQL functionality through user-defined functions that can then be evaluated in the SQL statement.

(Willie Favero) Discussing DSNZPARM keywords is a great pass time for many of us. In fact, ZPARMs are discussed so frequently that about 10 years ago we started to classify ZPARMs into three different states.

(Willie Favero) Discussing DSNZPARM keywords is a great pass time for many of us. In fact, ZPARMs are discussed so frequently that about 10 years ago we started to classify ZPARMs into three different states.

(Peter Crocker and Mark Walters) WebSphere Business Events V7.0.1 provides methods for implementing location-aware business event processing using spatial data. This article provides compelling real-world examples that implement geofence detection and proximity alerting. Such techniques have many us

(Scott Hayes) Episode #39 set a new record for studio audience attendee registrations. Attendees also rated this show very highly with comments like “all db2nightshows are great… and today’s one was no exception. thank you very much Scott&DBI” Our special guest was Julian Stuhler, Director Triton

(Paolo Bruni, Neale Armstrong, Ravi Kumar, Kirsten Ann Larsen, Tink Tysor and Hao Zhang) The DB2 pureXML feature offers sophisticated capabilities to store, process and manage XML data in its native hierarchical format. By integrating XML data intact into a relational database structure, users can t

(Jorge Machado and Hermann Voellinger) Designing the mappings for an extract, transform, and load (ETL) process is a critical step in a data warehouse project. Mappings must be easy to modify, capable of version control, easily reported, and easily exported to other formats.