XML parsing to database

Extensible Markup Language (XML) is a set of rules for encoding documents in machine-readable form.It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards.

XML parsing is the process of converting XML data from its serialized string format to its hierarchical format.You can let the DB2 database manager perform parsing implicitly, or you can perform XML parsing explicitly.

Implicit XML parsing occurs in the following cases:

* When you pass data to the database server using a host variable of type XML, or use a parameter marker of type XML The database server does the parsing when it binds the value for the host variable or parameter marker for use in statement processing.You must use implicit parsing in this case.

* When you assign a host variable, parameter marker, or SQL expression with a string data type (character, graphic or binary) to an XML column in an INSERT, UPDATE, DELETE, or MERGE statement. The parsing occurs when the SQL compiler implicitly adds an XMLPARSE function to the statement.