(Craig S. Mullins) DB2 9 for z/OS, the latest version of IBM’s stalwart mainframe relational DBMS, delivers a plethora of new features and functions. First among these new features is XML support as a native data type, but that’s not all there is. IBM has also added more SQL functionality, improved

(Damon Armstrong) In a previous blog entry (Date Errors Pulling DB2 Data into SQL Server) I recounted some of the issues I had with date conversions from DB2 to SQL Server.

(Itai Dinur, Ann Hayes, David Konopnicki and Eitan Shapiro) Does your company require specific content metadata or a custom look and feel within search applications? This article describes the IBM Search and Indexing API (SIAPI), now available with IBM WebSphere Portal V6.0, along with its design go

(Hernando Bedoya, Fredy Cruz, Daniel Lema and Satid Singkorapoom) Stored procedures, triggers, and user-defined functions (UDFs) are the key database features for developing robust and distributed applications. DB2 Universal Database for iSeries has supported these features for many years, and they

(Steven Goetjen) If you have ever needed to download DB2/400 data to your PC and view the data in MS Excel, as an HTML document, as a simple XML document, or just as a text file, you know how tricky this task can be. As a System i developer, I spend much of my time downloading information from the b

(Daniel Millwood and Martin Cocks) Service-Oriented Architecture (SOA) provides business agility and resilience through re-use, loose coupling, flexibility, interoperability, integration and governance. These benefits are realized by separating service descriptions from their implementations, and us

(Jarek Miszczyk, Robert Andrews, David Andruchuk, Hernando Bedoya and Emily Chun) XML represents a fundamental change in computing. It allows applications to move away from proprietary file and data formats to a world of open data interchange. XML has become ubiquitous not only because of its range

(Paul Zikopoulos) In a previous series of articles, I showed you the integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).

(Susan L. Cline) The three technologies used in the Web application demonstrated in this article are JSF, Facelets, and Java Database Connectivity (JDBC), which is used to access data stored in Apache Derby, a relational database. JSF is a Web application framework for building user interfaces (UIs)

(Bob Rumsby) Analysts across many industries — retail, banking, insurance, healthcare, telecommunications, government — need timely, accurate, and new information about their businesses to help them prosper in the marketplace. Retail companies, for example, collect huge amounts of transactional data