IBM Books

XML Extender Administration and Programming


Table of Contents

  • Tables

  • About this book
  • Who should use this book
  • How to get a current version of this book
  • How to use this book
  • Including this book in the DB2 UDB Version 7 Information Center
  • Highlighting conventions
  • How to read syntax diagrams
  • Related information

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