(Wolfgang Kulhanek) Using WebSphere Business Integration Server V4.2 to cross-reference business objects requires the use of stored procedures. This brief article provides the steps to configure DB2 V8.1 to enable stored procedure compilation.

(Ingrid Marson) IBM made its integrated middleware platform for the government, retail and banking sector available on the Linux operating system recently. The platform, which is already available on Windows and Unix, combines industry-specific middleware with its software portfolio including ap

(Wei-Dong Zhu) This IBM Redbook deals with IBM DB2 Content Manager implementation and migration. It is aimed at architects, designers, developers, and system administrators of Content Manager systems. We cover the basic concepts needed to design and implement a Content Manager solution. This incl

(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip)Conditional statements allow stored procedures to make decisions. They are used to define multiple branches of execution based on whether or not a condition was met.

(Owen Cline) This article will show how to use XML technology efficiently in business applications, and explain how to integrate your applications with DB2 Universal Database, DB2 XML Extender, WORF, WebSphere Application Developer and the WebSphere Application Server. You will learn how to desi

(Frank J. Ingrassia) Access path selection (APS) is the optimizer’s primary function—to choose the most efficient access path for each SQL statement executed by DB2. Access paths can be indexed or non-indexed, matching one or more columns against those indexes and/or screening predicates against col

(Ed Scannell and Cathleen Moore) This week, IBM will deliver its long awaited DB2 Information Integrator, codenamed Masala, whose sophisticated search engine will let corporate users dig out and analyse data across a heterogeneous range of information data stores.

Join us in Strasbourg, France on October 12-15, 2004 for the brand new Software Development Technical Conference. This new conference offers you the chance to gain a full and deep understanding of the software development world and how your organisation can meet your customers’ requirements. In

(Jianing Fan) SQL queries provide the backbone for Informix database applications. This article discusses guidelines for SQL query tuning for Informix, looks at factors you need to consider when tuning SQL queries, and examines some real life tuning examples gathered from the author’s experience

The following example shows a class for establishing a connection and gathering and displaying trace data under the DB2 Universal JDBC Driver. The class includes a method for the DriverManager interface and a method for the DataSource interface.