XML Extender Administration and Programming
Introduction
Introduction to the XML Extender
XML documents
XML applications
Why XML and DB2?
Integrating XML into DB2
Administration tools
Storage and access methods
DTD repository
Document Access Definitions (DADs)
XML column: Structured document storage and retrieval
XML collection: Integrated data management
Getting started with XML Extender
Scenario for the lessons
Lesson: Store an XML document in an XML column
The scenario
Planning
Setting up
Creating the XML column
Lesson: Composing an XML document
The tutorial scenario
Planning
Setting up
Creating the XML collection: preparing the DAD file
Composing the XML document
Cleaning up the tutorial environment
Administration
Preparing to use the XML Extender: administration
Set-up requirements
Software requirements
Installation requirements
Authorization requirements
Administration tools
Administration planning
Choosing an access and storage method
Planning for XML columns
Planning for XML collections
Administering XML data
Starting the administration wizard
Setting up the administration wizard
Invoking the administration wizard
Enabling a database for XML
Using the administration wizard
From the DB2 command shell
Storing a DTD in the DTD repository
Using the administration wizard
From the DB2 command shell
Defining XML columns or collections
Work with XML columns
Creating or editing the DAD file
Creating or altering an XML table
Enabling XML columns
Indexing side tables
Disabling XML columns
Work with XML collections
Creating or editing the DAD file for the mapping scheme
Enabling XML collections
Disabling XML collections
Disabling a database for XML
Before you begin
Using the administration wizard
From the DB2 command shell
Programming
Managing XML column data
UDT and UDF names
Storing data
Retrieving data
Retrieving an entire document
Retrieving element contents and attribute values
Updating XML data
Searching XML documents
Searching the XML document by structure
Using the Text Extender for structural text search
Deleting XML documents
Managing XML collection data
Composing XML documents from DB2 data
Before you begin
Composing the XML document
Dynamically overriding values in the DAD file
Decomposing XML documents into DB2 data
Enabling an XML collection for decomposition
Decomposition table size limits
Before you begin
Decomposing the XML document
Accessing an XML collection
Updating data in an XML collection
Deleting an XML document from an XML collection
Retrieving XML documents from an XML collection
Searching an XML collection
Reference
XML Extender administration command:
High-level syntax
Administration command options
enable_db
disable_db
enable_column
disable_column
enable_collection
disable_collection
XML Extender user-defined types
XML Extender user-defined functions
Storage functions
XMLVarcharFromFile()
XMLCLOBFromFile()
XMLFileFromVarchar()
XMLFileFromCLOB()
Retrieval functions
Content(): retrieve from XMLFILE to a CLOB
Content(): retrieve from XMLVARCHAR to an external server file
Content(): retrieval from XMLCLOB to an external server file
Extracting functions
extractInteger() and extractIntegers()
extractSmallint() and extractSmallints()
extractDouble() and extractDoubles()
extractReal() and extractReals()
extractChar() and extractChars()
extractVarchar() and extractVarchars()
extractCLOB() and extractCLOBs()
extractDate() and extractDates()
extractTime() and extractTimes()
extractTimestamp() and extractTimestamps()
Update function
Purpose
Syntax
Parameters
Return type
Example
XML Extender stored procedures
Specifying include files
Calling XML Extenders stored procedures
Before you begin
Administration stored procedures
dxxEnableDB()
dxxDisableDB()
dxxEnableColumn()
dxxDisableColumn()
dxxEnableCollection()
dxxDisableCollection()
Composition stored procedures
dxxGenXML()
dxxRetrieveXML()
Decomposition stored procedures
dxxShredXML()
dxxInsertXML()
Administrative support tables
DTD reference table
XML usage table
Diagnostic information
Handling UDF return codes
Handling stored procedure return codes
SQLSTATE codes
Messages
Error messages
Diagnostic tracing
Starting tracing
Stopping tracing
Appendixes
Appendix A. DTD for the DAD file
Appendix B. Samples
XML DTD
XML document: getstart.xml
Document access definition files
DAD file: XML column
DAD file: XML collection - SQL mapping
DAD file: XML - RDB_node mapping
Appendix C. Code page considerations
Encoding declaration
XML column and collection considerations
Supported code page settings
Hints and Tips
Notices
Trademarks
Glossary
Index
Contacting IBM
Product Information
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]