These samples are located in UNIX directory: sqllib/samples/xml/c and Windows directory: sqllib\samples\xml\c.
Type of XML sample | Sample program name | Program description |
---|---|---|
Administration | xmlschema.sqc | Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
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. | |
xmlindex.sqc | Create an index and use it in an XQuery. | |
xmlconst.sqc | Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
xmlload.sqc | Load XML documents into DB2 tables using the various LOAD command options. | |
Application Development | xmlinsert.sqc | Insert an XML document into a column of XML datatype. |
xmlupdel.sqc | Update and delete XML documents in the tables. | |
xmlread.sqc | Read XML data stored in tables. | |
reltoxmltype.sqc | Create an XML document from relational and XML data using SQL/XML publishing functions. | |
xmldecomposition.sqc | 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.sqc | Register a recursive XML schema to the XSR and enable it for decomposition. | |
xmltrig.sqc | Use the trigger processing capability for enforced automatic validation of incoming XML documents. | |
xmlintegrate.sqc | 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.sqc | 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.sqc | Use the XSLTRANSFORM function to convert XML documents residing in the database into HTML, plain text, or other forms of XML using style sheets. | |
simple_xmlproc.sqc | Simple stored procedure with XML type parameters. | |
simple_xmlproc_client.db2 | CLP script to call the routine in simple_xmlproc.sqc | |
simple_xmlproc_create.db2 | CLP script to register the stored procedure in simple_xmlproc.sqc | |
simple_xmlproc_drop.db2 | CLP script to drop the stored procedure in simple_xmlproc.sqc |