DB2 Version 10.1 for Linux, UNIX, and Windows

pureXML - CLI samples

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

Table 1. pureXML - CLI sample program files
Type of XML sample	Sample program name	Program description
Administration	`xmlindex.c`	Create an index and use it an XQuery.
	`xmlconst.c`	Create index with UNIQUE and VARCHAR length constraints using XML patterns.
	`xsupdate.c`	Update a registered XML schema ensuring that the original and the new schemas are compatible.
Application Development	`xmlinsert.c`	Insert an XML document into a column of XML datatype.
	`xmlupdel.c`	Update and delete XML documents in the tables.
	`xmlread.c`	Read XML data stored in tables.
	`reltoxmldoc.c`	Create an XML document from data stored in relational tables using various SQL/XML publishing functions.
	`xmltotable.c`	Insert the data from XML document to relational tables using SQL/XML functions
	`simple_xmlproc.c`	Simple stored procedure with XML type parameters
	`simple_xmlproc_client.c`	Client program to call the routine in simple_xmlproc.c.
	`simple_xmlproc_create.db2`	CLP script to register the stored procedure in simple_xmlproc.c
	`simple_xmlproc_drop.db2`	CLP script to drop the stored procedure in simple_xmlproc.c