(Raul F. Chong) This article shows DB2 UNIX, Linux, and Windows specialists how to leverage their DB2 knowledge in these platforms to gain skills on DB2 for iSeries.
Other News
DTCTest.exe – Testing Distrubuted Transactions
BulkXML is a command line wrapper around the XML bulk load interface SQLXMLBulkLoad, which was introduced in SQLXML.
INF: Creating Databases or Changing Disk File Locations on a Shared Cluster Drive on Which SQL Server 2000 was not Originally Installed
After you install a SQL Server 2000 virtual server instance, you may want to create databases, or move existing data or log files onto a secondary shared cluster disk. To create databases, or move existing data or log files, the other disk that SQL Server is to use must be added as a dependency
Actualizing Grid Management
(Alan Joch) By tying together massive amounts of server, application, and storage components into a collective whole, enterprise computing grids can create cost-effective virtual “computers” of unmatched power and speed, where the negative effects of spikes in demand become a thing of the past.
Replication Gotcha – Columns with Defaults
(Andy Warren) If you’re read my assorted articles over the past couple years you’ll know that I’ve done a fair bit with transactional replication. I wouldn’t call myself an expert with it, but I’m comfortable using it in production and dealing with the minor mishaps that occur. Still, there is alway
How do you generate random numbers in DB2?
(Robert Catterall) If you want to generate a random number to populate a column in a DB2 table, you have a number of options, divided into two broad categories: generate the value outside of DB2 or use a DB2 facility to generate the value.
Writing XML Using OPENXML
OPENXML is a Transact-SQL keyword that provides a rowset over in-memory XML documents. OPENXML is a rowset provider similar to a table or a view. OPENXML allows access to XML data as if it is a relational rowset by providing a rowset view of the internal representation of an XML document. The record
A Simple Introduction to Using DB2 Information Integrator with Oracle 9i
(Sridhar Reddy Varakala and Kulvir Singh Bhogal) If you are interested in information integration but haven’t had the time to pick up the basics, this article offers a gentle but quick introduction to the capabilities of DB2 Information Integrator for integrating and updating data in an Oracle datab
Oracle unveils native BPEL engine
(John K. Waters) Oracle Corp. unveiled what it called “the industry’s first and most complete” Service-Oriented Architecture (SOA) platform. Based on technology acquired with its recent purchase of Collaxa Inc., Oracle’s new BPEL Process Manager features what the company claims is the first native B
Integrating Portable XML Data with Portable C/C++ Code
(Zhaoqing Wang and Harry H. Cheng) XML is changing the world of information sharing and exchange. The XML standard allows users to clearly define their own data and documents in an open, platform-, vendor-, and language-neutral manner for tasks such as electronic data interchange, data management, a