pureXML - SQLJ samples
These samples are located in UNIX directory: sqllib/samples/xml/sqlj
and
Windows directory: sqllib\samples\xml\sqlj
.
Type of XML sample | Sample program name | Program description |
---|---|---|
Administration | XmlSchema.sqlj |
Register the XML schema to the database and use the registered schema to validate and insert an XML document. |
XmlIndex.sqlj |
Create an index and use it in an XQuery query. | |
XmlConst.sqlj |
Create an index with UNIQUE and VARCHAR length constraints using XML patterns. | |
Application Development | XmlInsert.sqlj |
Insert an XML document into a column of XML datatype. |
XmlUpDel.sqlj |
Update and delete XML documents in the tables. | |
XmlRead.sqlj |
Read XML data stored in tables. | |
RelToXmlDoc.sqlj |
Create an XML document directly from data stored in relational tables using SQL/XML publishing functions. | |
RelToXmlType.sqlj |
Create an XML document from relational and XML data using SQL/XML publishing functions. | |
XmlToTable.sqlj |
Insert the data from an XML document into relational tables using SQL/XML functions like XMLTABLE, XMLQUERY and the XMLEXISTS predicate. | |
XmlIntegrate.sqlj |
Use the XMLROW and XMLGROUP functions for mapping relational data to XML. Demonstrate XMLQuery default passing mechanism and the default column specification for XMLTABLE. | |
XmlXslt.sqlj |
Use the XSLTRANSFORM function to convert XML documents residing in the database into HTML, plain text, or other forms of XML using style sheets. |