https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnseconds-from-datetime-function
Db2 13 - pureXML guide - fn:seconds-from-dateTime function
The fn:seconds-from-dateTime function returns the seconds component of an xs:dateTime value that is in its localized form.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=document-non-empty-sequences-returned-by-xmlquery
Db2 13 - pureXML guide - Non-empty sequences returned by XMLQUERY
If evaluation of the XQuery expression that you specify in XMLQUERY results in a non-empty sequence, the XMLQUERY function returns that sequence.
non emptydb213purexmlguide
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=expressions-conditional
Db2 13 - pureXML guide - Conditional expressions
Conditional expressions use the keywords if, then, and else to evaluate one of two expressions based on whether the value of a test expression is true or false.
db213purexmlguideconditional
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnround-function
Db2 13 - pureXML guide - fn:round function
The fn:round function returns the integer that is closest to the specified numeric value.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnabs-function
Db2 13 - pureXML guide - fn:abs function
The fn:abs function returns the absolute value of a numeric value.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=constructors-direct-comment
Db2 13 - pureXML guide - Direct comment constructors
Direct comment constructors use an XML-like notation to create comment nodes.
db213purexmlguidedirect
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=validation-xml-schema-ignorable-whitespace
Db2 12 - pureXML guide - XML validation and ignorable whitespace
XML schema validation removes ignorable whitespace from a document.
xml validationdb212purexmlguide
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnstring-length-function
Db2 13 - pureXML guide - fn:string-length function
The fn:string-length function returns the length of a string.
string lengthdb213purexmlguide
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fntimezone-from-datetime-function
Db2 13 - pureXML guide - fn:timezone-from-dateTime function
The fn:timezone-from-dateTime function returns the time zone component of an xs:dateTime value.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=considerations-xml-data-encoding-in-jdbc-sqlj-applications
Db2 13 - pureXML guide - XML data encoding in JDBC and SQLJ applications
In general, Java applications have fewer XML encoding issues than Db2 ODBC or embedded SQL applications because the application code page is always Unicode.
xml data
https://www.ibm.com/docs/en/db2/12.1.x?topic=perl-purexml
pureXML and Perl
The DBD::DB2 driver supports Db2 pureXML. Support for pureXML allows more direct access to your data through the DBD::DB2 driver and helps to decrease...
purexmlperl
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=constructors-processing-instruction
Db2 13 - pureXML guide - Processing instruction constructors
Processing instruction constructors create processing instruction nodes. Db2 for z/OS supports direct constructors for creating processing instruction nodes.
processing instructiondb213purexmlguide
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=xml-purexml-data-model
Db2 13 - pureXML guide - pureXML data model
The pureXML data model follows the XPath 2.0 and the XQuery 1.0 data model. This data model provides an abstract representation of one or more XML documents or...
db213purexmlguidedata
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=processing-atomization
Db2 13 - pureXML guide - Atomization
Atomization is the process of converting a sequence of items into a sequence of atomic values. Atomization is used by expressions whenever a sequence of atomic...
db213purexmlguideatomization
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=prologs-namespace-declarations
Db2 12 - pureXML guide - Namespace declarations in XQuery
A namespace declaration is an optional declaration in the XQuery expression prolog that declares a namespace prefix and associates the prefix with a namespace...
db212purexmlguidenamespace
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-fnname-function
Db2 13 - pureXML guide - fn:name function
The fn:name function returns the prefix and local name parts of a node name.
db213purexmlguidefn
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=xeivrfx-xmltable-example-specifying-default-value-column-in-result-table
Db2 13 - pureXML guide - XMLTABLE example: Specifying a default value for a column in the result...
You can specify a default value for any column in the XMLTABLE result table by using a DEFAULT clause. The default value is used if the XQuery expression that...