pureXML - CLP samples

These samples are located in UNIX directory: sqllib/samples/xml/clp and Windows directory: sqllib\samples\xml\clp.

Table 1. pureXML - CLP sample program files
Type of XML sample	Sample program name	Program description
Administration	`xmlschema.db2`	Register the XML schema to the database and use the registered schema to validate and insert an XML document.
	`xmldbafn.db2`	Use of inline DBA functions to determine the estimated inline length for XML documents.
	`xmlolic.db2`	Reorganizes the indexes defined on a table and how to reorganize nonpartitioned indexes on a range-partitioned table.
	`xsupdate.db2`	Update a registered XML schema ensuring that the original and the new schemas are compatible.
	`xmlrunstats.db2`	Perform RUNSTATS on a table containing XML type columns.
	`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.
	`xmlindex.db2`	Create an index and use it in an XQuery query.
	`xmlconst.db2`	Create index with UNIQUE and VARCHAR length constraints using XML patterns.
Application Development	`xmlinsert.db2`	Insert an XML document into a column of XML datatype.
	`xrpart.db2`	Use of XML in range partitioned tables and support for local and global indexes.
	`xmlpartition.db2`	Use of XML in partitioned database environment, MDC and range partitioned tables.
	`xmlmdc.db2`	Moves data from MDC to non-MDC tables and use of block indexes, global indexes, and faster insertion and deletion.
	`xmludfs.db2`	Pass the XML data type as an input parameter, and return values when using scalar functions, sourced functions, SQL-bodied UDFs and table UDFs.
	`xmlindgtt.db2`	Use of declared global temporary tables with the XML data type.
	`xmlupdel.db2`	Update and delete XML documents in the tables.
	`reltoxmldoc.db2`	Create an XML document directly from data stored in relational tables using various SQL/XML publishing functions.
	`reltoxmltype.db2`	Create an XML document from relational and XML data using SQL/XML publishing functions.
	`xmldecomposition.db2`	Decompose data stored in an XML file and insert the data into tables. Specify the order of insertion to be used during XML document shredding.
	`recxmldecomp.db2`	Register a recursive XML schema to the XSR and enable it for decomposition.
	`simple_xmlproc.db2`	Simple stored procedure with XML type parameters.
	`xmltotable.db2`	Insert the data from an XML document into relational tables using SQL/XML functions like XMLTABLE, XMLEXISTS and XMLQUERY.
	`xmltrig.db2`	Use the trigger processing capability for enforced automatic validation of incoming XML documents.
	`xmlintegrate.db2`	Use the XMLROW and XMLGROUP functions for mapping relational data to XML. Demonstrate XMLQuery default passing mechanism and the default column specification for XMLTABLE.
	`xmlcheckconstraint.db2`	Create tables with check constraints on an XML column using IS VALIDATED and IS NOT VALIDATED predicates and specify one or more schemas using the ACCORDING TO XMLSCHEMA clause.
	`xmlxslt.db2`	Use the XSLTRANSFORM function to convert XML documents residing in the database into HTML, plain text, or other forms of XML using style sheets.