The CURRENT IMPLICIT XMLPARSE OPTION special register specifies
whitespace handling options that are to be used when serialized XML
data is implicitly parsed by the DB2® server
without validation.
An implicit non-validating parse operation occurs when an
SQL statement is processing an XML host variable or an implicitly
or explicitly typed XML parameter marker that is not an argument of
the XMLVALIDATE function.
The data type of the register is VARCHAR(128). The supported
values are:
- STRIP WHITESPACE
- Whitespace that is in the document to improve readability is removed.
The whitespace characters are: blank, carriage return, line feed,
and tab. All boundary whitespace (whitespace between elements) is
removed.
- PRESERVE WHITESPACE
- No whitespace is removed,
The initial value of CURRENT IMPLICIT XMLPARSE OPTION is
'STRIP WHITESPACE'.
Example
Set the CURRENT IMPLICIT XMLPARSE
OPTION to PRESERVE WHITESPACE.
SET CURRENT IMPLICIT XMLPARSE OPTION = PRESERVE WHITESPACE