UDT

Description

 

 

XMLCLOB

Stores large XML documents with the base type CLOB,

 

up to 2 GIG

 

 

XMLFile

References an external XML document file using the

 

base type VARCHAR(512)

 

 

This means that you will have to provide the qualifier for each reference to a UDT, UDF, table or stored procedure created by the extender.

Table 6-3 UDFs created

UDF

Description

 

 

XMLVarcharFromFile

Import XML document from a file to a XMLVarchar

 

column

 

 

XMLCLOBFromFile

Import XML document from a file to a XMLCLOB

 

column

 

 

XMLFileFromVarchar()

Import XML document from a XMLVarchar column to

 

XML file

 

 

XMLFileFromCLOB()

Import XML document from a CLOB column to XML

 

file

 

 

Content()

Export XML document from XMLVarchar, XMLCLOB or

 

XMLFile

 

 

extract functions

For example, find an element/attribute within an

 

XML document that only has a single value

 

 

Update()

Replace XML document stored in XML columns by

 

changing some element or attribute value

 

 

For example, if you want to refer the data type XMLVarchar in a SQL statement, you will refer it as DB2XML.XMLVarchar.

Table 6-4 Stored Procedures created

Stored Procedure

Description

 

 

dxxEnableDB()

Enable database for XML

 

 

dxxDisableDB()

Disable database for XML

 

 

dxxEnableColumn()

Enable table column for XML data

 

 

dxxDisableColumn()

Disable table column for XML data

 

 

dxxEnableCollection()

Enables a collection of tables for XML

 

 

dxxDisableCollection()

Disables an enabled collection

 

 

Chapter 6. RDB and XML integration 129

Page 145
Image 145
IBM Version 5 manual UDFs created, Stored Procedures created