Since the XML data is self-describing, you don't have to give additional information with it. It will be accepted as long as it is well-formed. You can also create an XML index to speedup your searches of the XML data. This requires the index key to defined using an "xmlpattern", which is an XPath expresssion (no predicates, ofcourse) to identify the subset of the XML document. You will also have to specify the SQL datatype represented by the subset selected by the XPath expression. For example:
create table case (
primary key not null,
The following is a list of the features provided with DB2 Viper
create index caseIndex on case(arraignmentNotice)
generate key using xmlpattern '/arraignmentNotice/date'
as sql DATE
- Efficient storage techniques for managing XML data in hierarchical format.
- Support for indexing XML data
- Support for XQuery as well as SQL (with XML extensions) to query XML data
- Support for validating XML data using schemas
- API support for popular languages like Java, C, COBOL and .NET platform
- An Eclipse based developer's workbench which includes a graphical XQuery builder.