DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
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 |