White Papers

XMLTABLE by Example, Part 2: Common Scenarios for Using XMLTABLE With DB2 - Get the Most Out of This SQL/XML Function

Overview The XMLTABLE function is a very versatile tool for processing XML data in SELECT and INSERT statements. In this paper, one will see how XMLTABLE can be deployed to split big XML documents into small ones, to perform simple XML shredding, or to produce a hybrid representation of your XML data. This two-part series on XMLTABLE contains a wide range of SQL/XML statement samples that one may be able to use as templates for some of one's own application development.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
IBM
File Format
HTML
Date Published
Mar 29, 2008
Format
White Papers
Topics
XML, Database Management

Similiar White Papers

Update XML in DB2 9.5

Update XML in DB2 9.5

One of the most significant new features in IBM DB2 9.5 for Linux, Unix and Windows is the XML update functionality. The

Publisher: IBM  |  Tags: data, database, linux, server

Mashing Google Maps With Oracle Database

Mashing Google Maps With Oracle Database

As one may know, Oracle has had the ability to generate XML on the fly from the database for a number of years. In addit

Publisher: Oracle  |  Tags: api, data, database, google maps, java

What's New for XML in SQL Server 2008

What's New for XML in SQL Server 2008

Microsoft introduced XML-related capabilities in Microsoft SQL Server 2000 with the FOR XML and OPENXML Transact-SQL key

Publisher: Microsoft  |  Tags: data, database, developers, keywords, xml

DB2 9 and z/OS XML System Services Synergy Update

DB2 9 and z/OS XML System Services Synergy Update

DB2 9 is a hybrid data server with integrated pureXML technology to natively manage XML data with unprecedented reliabil

Publisher: IBM  |  Tags: data, management, os, server

Query DB2 XML Data With SQL

Query DB2 XML Data With SQL

The DB2 Viper release, now in beta, features significant new support for storing, managing, and querying XML data. In th

Publisher: IBM  |  Tags: beta, data

IBM White Papers

Integrated Change & Release Management

Integrated Change & Release Management

Short deadlines and constant change epitomize the challenges of software and systems development. Routine change increas

Publisher: IBM  |  Tags: software

Webcast: Introducing IBM Lotus Quickr -- The Fastest Way to Share Content with Your Teams

Webcast: Introducing IBM Lotus Quickr -- The Fastest Way to Share Content with Your Teams

Have you heard the buzz about Lotus Quickr? Lotus Quickr is IBM's new Web 2.0-based team collaboration software that is

Publisher: IBM  |  Tags: collaboration software, software

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview

Publisher: IBM  |  Tags: cost savings, server

Build Strong, Flexible J2EE apps With a WebSphere Cluster Environment

Build Strong, Flexible J2EE apps With a WebSphere Cluster Environment

When building a strong, extensible, and flexible J2EE application, one needs to consider several factors. One important

Publisher: IBM  |  Tags: application server, management, server

Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features

Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features

The IBM System Storage DS8000 and DS6000 Disk Storage systems are both high performance storage systems that offer expan

Publisher: IBM  |  Tags: data, database, server