(Lijun (June) Gu) IBM DB2 Replication (called DataPropagator on some platforms) is a powerful, flexible facility for copying DB2 and/or Informix data from one place to another. The IBM replication solution includes transformation, joining, and the filtering of data. You can move data between differ
Other News
XML: Leading the March to Web Services
(A. Russell Jones) The concept of Web services wasn’t so much a good idea that people backed with new technology, but the logical, inevitable result of the creation of a universal file format. Find out why XML is the genesis of just about everything there is to love about future Web-based business a
XML Support in Transact-SQL
(Baya Pavliashvili) The AUTO mode of the FOR XML extension lets you use subqueries, which can be a useful trick for certain XML formatting needs. Subqueries can be used for a variety of reasons, one of them being limiting the returned result set.
Make XML Native and Relative
(Jonathan Gennick) XML is fast becoming the language of choice for data interchange between businesses. However, most businesses store their data in relational databases such as Oracle9i Database. So how do you bridge the gap between the hierarchical, document-centric world of XML and the tabular, s
Oracle Background Processes
(Amar Kumar Padhi) An Oracle instance runs two types of processes – Server and Background. Server processes are created to handle requests from sessions connected to the instance. Background processes, as the name says, are processes running behind the scene and are meant to perform certain main
When configuring DB2, default equals danger
(Robert Westervelt) While most DBAs think they are aware of the various configurations that are required to build a high-performance DB2 database, one expert said too many database pros settle for program defaults that can cause inefficiencies and even system failures. (R)
.NET Data Persistence: SQL Server vs. Matisse vs. FastObjects
(livebet) Almost every enterprise development I have done or seen begins with design and definition of the data-base. Even when the system was developed using pure OO methodologies, coding begins with the database. Recently, whenever I have told my developers to develop the enterprise such that
Understanding Error Handling
(Vinod Kumar) This is an interesting subject to discuss. I’ve not been a big supporter of what happens in our error handling in SQL. And there are quite a lot of void spaces that needs to be addressed in the SQL documentation for the same. Here are some of the tips you can use in your application co
DB2 Basics: Exploit file type modifiers that are built into the DB2 data movement utilities
(Roman B. Melnyk) The DB2 data movement utilities — export, import, and load — support a variety of options that depend on the type of file used to move data in or out of database tables. These file type modifiers significantly broaden the capabilities of the data movement utilities, and can b
Oracle 10g: Putting Grids to Work
(Dan Kusnetzky and Carl W. Olofson) IDC believes that organizations wishing to move in an evolutionary way to Grid/Utility Computing architectures would be well advised to consider Oracle’s Oracle 10g family of products. Applications currently written for Oracle’s application server or data mana