(Craig Mullins) In Oracle DECODE can be used in a where clause. For example: WHERE DECODE (deptno,10,’HR’, 20,’Sales’) = ‘Sales’ How can this be achieved in a DB2 query with the CASE statement? (R)
Other News
IBM Looks to Ease XML Integration
A utility in the works at IBM hopes to fill the gap between XML documents and content respositories by automating what is now a time-intensive process. Code-named “Cinnamon”, the utility will shed its spicy nickname and be incorporated into IBM’s DB2 Content Manager some time next year. As part o
Web services Programming Tips and Tricks: WSDL file imports
(Russell Butek) Import statements are easy, right? Just about every programming or interface language has them; and if you’re reading this tip, you probably know everything there is to know about imports. So, why should you read a tip about Web Services Description Language (WSDL) file imports? For
Creating a CMT Stateless SessionBean Facade for an Application Module
(Steve Muench) BC4J provides automatic facilities for deploying any application module as a stateful EJB session bean. If you want to leverage the features of your BC4J application module from a stateless EJB session bean, it’s not automatic but it is straightforward to implement. This howto article
INFO: IBM DB2 Driver Available for Use with MTS
The new International Business Machines (IBM) DB2 ODBC driver fully supports Microsoft Transaction Server (MTS), including connection pooling and automatic transaction enlistment. The update, known as MTS Hotfix 0722 for MTS 2.0, allows MTS applications to update IBM’s DB2 databases on a wide va
Improve Your Scripting with the test Command
(Emmett Dulaney) Underlying every conditional statement is a test to see what is true and what is not. Knowing how this works can make the difference between writing mediocre scripts and ones you’ll be proud of. The all too often underappreciated shell script is limited in power only by the abil
Reporting Strictly for Developers: Microsoft SQL Server Reporting Services
(Anthony Glenwright) Most report design tools attempt to please both developers and non-technical end users by combining high levels of flexibility and power and ease-of-use. This accommodation naturally requires various sacrifices on both sides. With the Reporting Services Report Designer, Micr
The Evolution of Data-Oriented Services
(Matthew Zager) My colleague wrote an article for XML-J two years ago about an opportunity we had to solve our data management challenges with XML. The result of our work was our XML Data Services (XDS), an XML data access language and processing engine, which allowed us to quickly and easily manage
Finding File-Creation Time
(Brian Moran) Does SQL Server keep track of when new files and filegroups are added to or removed from a database, maybe in the form of a timestamp in the catalog? If so, how can I access that information? (R,$)
Good News for Enterprise Java Applications on DB2
(Pat Selinger, Curt Cotner, Maryela Weihrauch and Heather Lamb) Many of IBM’s customers are at least piloting, if not wholeheartedly committed to writing, their new applications in Java. These applications are often mission-critical which means that having high performance, security, and consistency