SQL/XML and XQuery support - IBM DB2

An XQuery or SQL/XML statement can be executed in the same manner as we execute an SQL statement in the JDBC application. All the restrictions of XQuery are also applicable here. For the XQuery statement, the query should be prefixed with the xquery word.

For more details about how to write an XQuery, refer to Chapter , “Application development with DB2 pureXML”. Example shows how to run an XQuery statement in Java. This XQuery gives all the customers’ cities in Canada.

Running XQuery

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM DB2 Topics