(Justin Whitney) With the addition of “pureXML” to IBM DB2 9, database developers gain powerful XQuery functionality. For those new to the syntax (and for veterans seeking a faster way to build complex queries), the new DB2 Developer Workbench includes the Visual XQuery Builder, a versatile visual d

(Dinesh G Shetty, Srinandan K Sridhar and Andre Tost)IBM recently shipped a new version of its flagship database product, DB2 Version 9. With this release comes first class support for XML documents, including the ability to store and query XML documents without the need to map them into a relationa

(Xiao Li and Sheng Wei) The pClient and eClient, packaged with IBM DB2 Content Manager (CM), meet the client requirements of many Content Manager users. However, many others need to develop their own client applications to meet their special business needs and to integrate their own business with CM

Many applications, OLAP and data warehousing in particular, usually consider several attributes as dimensions for processing and maintenance. Performance and scalability of queries in this type of environment can be slow using the traditional relational-database approach based on one-dimensional clu

(Dave Royer) IBM DB2 Document Manager is a powerful document management middle-tier server that integrates with IBM DB2 Content Manager as a repository for documents throughout their lifecycle. This article is written for administrators of Document Manager middle-tier servers. It assumes familiarity

(Willie Favero) So, you’ve just finished running DSNTIJNE moving your DB2 subsystem or data sharing group into enable new function mode (ENFM). You also read some dude’s blog that said all you need to do is run a few queries to make sure the catalog was still there and survived the conversion from E

(Hardeep Singh) Your knowledge of popular programming languages and techniques is all you need to put DB2 9’s XML capabilities to work in service-oriented architectures and other business scenarios.

(Kevin Yeung-Kuen See) Transfer ownership is a new DB2 9 feature where the ownership of a database object can transfer to another authorization ID (authid). There are two general usages for this feature. The first usage is when the owner of an SQL object leaves a company, the ownership of the object

(Craig Mullins) One of the long-standing, troubling questions in DB2-land is when to use VARCHAR versus CHAR. The high-level advice for when to use VARCHAR instead of CHAR is for larger columns whose length varies considerably from row-to-row. Basically, VARCHAR should be used to save space in the d

(Willie Favero) Yup, every new version and release of DB2 has them. They are words that you cannot use in an SQL statement under penalty of error (-199 or DSNH083I) unless they are a delimited identifier (mark off by a quotation mark (") for example). And why might they be a problem? Well, DB2 might