(C.M. Saracco) It’s a common problem that often requires an uncommon solution: business analysts want integrated, Web-based access to critical corporate data. Sounds simple, right? Well it can be, if all this data is stored in a single relational database, such as IBM’s DB2 Universal Database (D
Other News
Tracing SQL in Oracle Database 10g
(Kimberly Floss)In a busy production environment with many active users, tracing a SQL session is time-consuming and complicated, because processing SQL statements in any multitier system that uses a connection pool can span multiple processes, or even different instances. With Oracle Database 1
SQL Server 2005 Data Transformation Services (DTS) – A First Look
(Srinivas Sampath) Before we begin the discovery of this new tool, there is one word that can immediately describe it: WOW!! That is the first reaction I had when I started playing around with DTS. Its a totally different beast in SQL Server 2005 and is a lot better than the SQL Server 2000 coun
Principles of XML design: Considering container elements
(Uche Ogbuji) A critical issue in designing XML formats is figuring out how to arrange elements and represent relationships between them. Element design works best when it naturally corresponds to how people think about the concepts that each element represents. This article discusses best pract
Replicate data in the fast lane
Q replication is a new, high-speed technology for moving transactions between DB2 databases. It’s a highlight of the just-released DB2 Information Integrator Version 8.2. One of the reasons Q replication is so fast is that it uses the powerful business integration product WebSphere MQ to zoom data a
ODBC support for Cloudscape
(Susan L. Cline) ODBC support is available for the Cloudscape 10.0 GA and Derby databases as an IBM DB2 Run-Time client. This article discusses supported platforms, system requirements and information about where to download the free driver.
The End Is in Sight for Paper-Intensive Transactions
(Bruce Silver) For 30 years, a few strident voices have warned us that the world is running out of oil. With low energy prices, it used to be easy for some to dismiss them as tree-hugging cranks, but now with oil costing more than $40 per barrel and rising, maybe their dire predictions are finally c
SQL Server 2000 Security – Part 12 – Auditing with Meta Data Services
(Marcin Policht) In our previous two articles of this series, we discussed auditing and security related aspects of SQL Server 2000 Data Transformation Services. Now, we will combine these topics by presenting DTS Meta Data Services, which provides the ability to audit creation, execution, and modif
Getting the Most Out of SQL*Loader Direct Path Loads
(Richard Phillips) There are four SQL*Loader direct path load parameters that directly affect the elapsed time of direct path load operations: –READSIZE is the size of the buffer used to read data from input data files. –COLUMNARRAYSIZE is the number of rows in a two-dimensional array used
INF: How to Overcome the 32 KB Limit for SQL Expressions
Analysis Services limits the length of SQL expressions to 32 KB. Some applications require complex SQL Case expressions to define member names and keys, which would exceed the 32 KB limit. This article explains how you can work around the 32 KB limit.