Informix XPS and DB2 UDB support the concept of synonyms. This Technote discusses the use of synonyms with both databases.

MQTs are a powerful way to improve performance and response time for complex queries, particularly those associated with analyzing large amounts of data. This Technote discusses the considerations and approaches for configuring MQTs appropriately.

(Larry J. Seltzer) The top threat this week is not a real-world threat yet, but Winxor.A portends a new wave of worms that use a bug in Windows servers to spread far and wide. See the Top Threat Section for details.

IBM is renaming the IBM DB2 Information Integrator product portfolio to IBM WebSphere Information Integrator. According to IBM sources, the WebSphere brand represents integration and infrastructure software to maximize business flexibility and responsiveness, and it is a natural move to integrate it

(Peter Bendel) IBM DB2 Alphablox is the new IBM offering that enables users to develop custom Web-based analytic applications for relational databases, such as DB2, relational cubes in DB2 (star schema), or multidimensional databases, such as IBM DB2 OLAP Server. In this article learn how you can us

(Craig Mullins) I have a condition where I have to select only the first row from a SQL query. select b.status from credit_source a,credit b, credit_Status c where a.credit_source_id = b.credit_source_id and b.status = c.status order by c.weight desc fetch first rows only This statement

(Thomas M. Stockwell) On December 29, 2004, Oracle assumed control of PeopleSoft, the software vendor that merged with J.D. Edwards in 2003. Industry analysts see this as one more example of Larry Ellison’s crass and crafty abduction of IBM territory. Yet, beyond the media circus that surrounded the

This utility augments the included tutorial “DB2 Application data access with DB2 II and WBI” by automating the steps necessary for configuring DB2 Information Integrator 8.2, WebSphere Business Integration (WBI) Adapters 2.3.1, and WebSphere MQ 5.3.0.1 to access customer relationship management (CR

(Claus Samuelsen) Communication between different applications is becoming increasingly important. Whether you are implementing a full-blown Service Oriented Architechture or just need to transfer data between two systems, IBM WebSphere MQ is a solid foundation for data exchange. While IBM Infor

(Andrew Binstock) The release earlier this year of IBM DB2 version 8.2 (code-named Stinger) heralded several key advances in developer support for Big Blue’s flagship database. I discussed many of these here. In a nutshell, they include significant integration with Visual Studio .NET, great Java and