These samples demonstrate pureXML support for various administration features, including: XML schema support, Utility support, XML data indexing support.
Samples By Language | Sample program name | Program description |
---|---|---|
CLI | xsupdate.c | Update a registered XML schema ensuring that the original and the new schemas are compatible. |
C | xmlschema.sqc | Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
CLP | xmlschema.db2 | Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
xsupdate.db2 | Update a registered XML schema ensuring that the original and the new schemas are compatible. | |
JDBC | XmlSchema.java | Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
XsUpdate.java | Update a registered XML schema ensuring that the original and the new schemas are compatible. | |
SQLJ | XmlSchema.sqlj | Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
Samples By Language | Sample program name | Program description |
---|---|---|
C | xmlrunstats.sqc | Perform RUNSTATS on a table containing XML type columns. |
lobstoxml.sqc | Move LOB data into an XML column using IMPORT and EXPORT commands. | |
impexpxml.sqc | Import and Export XML documents. | |
xmlload.sqc | Load XML documents into DB2 tables using the various LOAD command options. | |
CLP | xmlrunstats.db2 | Perform RUNSTATS on a table containing XML type columns. |
xmlolic.db2 | Reorganizes the indexes defined on a table and how to reorganize nonpartitioned indexes on a range-partitioned table. | |
xmldb2batch.db2 | db2batch support for XML datatype. | |
xmldb2look.db2 | db2look support for XML datatype. | |
lobstoxml.db2 | Move LOB data into an XML column using IMPORT and EXPORT commands. | |
impexpxml.db2 | Import and Export XML documents. | |
xmlload.db2 | Load XML documents into DB2 tables using the various LOAD command options. | |
JDBC | XmlRunstats.java | Perform RUNSTATS on a table containing XML type columns. |
Samples By Language | Sample program name | Program description |
---|---|---|
C | xmlindex.sqc | Create an index and use it in an XQuery query. |
xmlconst.sqc | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
CLI | xmlindex.c | Create an index and use it in an XQuery query. |
xmlconst.c | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
CLP | xmlindex.db2 | Create an index and use it in an XQuery query. |
xmlconst.db2 | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
JDBC | XmlIndex.java | Create an index and use it in an XQuery query. |
XmlConst.java | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
SQLJ | XmlIndex.sqlj | Create an index and use it in an XQuery query. |
XmlConst.sqlj | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. |