Articles & Content


SQL/XML in Viper: The snake's venom (E11)

Topic: DB2 for LUW

Subtopic: 2005

DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: Henrik Loeser (IBM Silicon Valley Lab)

The SQL/XML standard defines XML-related functionality. In this presentation we give a sneak peek of SQL/XML support in the project Viper. Using SQL/XML functionality it is possible to integrate both worlds: XML data can be queried from within SQL, relational data can be turned into XML, single values extracted from an XML document or an XML query result transformed into a table for further processing.

EXP. LEVEL: Beginner,Intermediate


SQL/XML support in Viper

Publishing functions

Querying XML data from within SQL

Transforming XML results into table format

Validating XML documents

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.