Finally! Bring native XML data into your relational database using DB2 Express-C

Level: Introductory

Eric Long (elong@us.ibm.com), Software Engineer, IBM　

07 Aug 2007

	Register now or sign in using your IBM ID and password.

Learn how to use the new features of DB2® Express-C to store, query, and manipulate native XML documents using SQL/XML and XQuery. Previously, XML documents had to be "shredded," or turned into a CLOB/BLOB/LOB (large object), to be stored in a relational database. This tutorial explains how to handle XML documents natively in the no-cost, open community DB2 Express-C and DB2 Developer Workbench. Learn how to create a new database, create a table with XML and relational columns, populate the table, and query XML data with XQuery.

In this tutorial

Share this tutorial Digg this story Post to del.icio.us Slashdot it!

Objectives

• Install and set up DB2 Express-C
  
  
• Use DB2 Developer Control Center to create a new database
  
  
• Create data (both relational and native XML) into the database
  
  
• Use XQuery and SQL/XML to query the XML and relational data with DB2 Developer Workbench
  

Prerequisites

This tutorials assumes that you have some understanding of XML, SQL, and basic database design. Knowledge of XQuery and SQL/XML functions will be helpful, but are not required.

System requirements

To complete the steps in this tutorial, you need to have DB2 Express-C installed.

Duration

1 hour

Formats

Share this.... Digg this story del.icio.us Slashdot it!

Back to top