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 |
|
|