pureXML - CLI samples
These samples are located in UNIX directory: sqllib/samples/xml/cli
and
Windows: sqllib\samples\xml\cli
.
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 |