CURRENT IMPLICIT XMLPARSE OPTION special register
The CURRENT IMPLICIT XMLPARSE OPTION special register specifies the whitespace handling options that are to be used when serialized XML data is implicitly parsed by the database 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(19).
The value of the CURRENT IMPLICIT XMLPARSE OPTION special register can be changed by invoking the SET CURRENT IMPLICIT XMLPARSE OPTION statement. Its initial value is 'STRIP WHITESPACE'.
Examples
- Retrieve the value of the CURRENT IMPLICIT XMLPARSE OPTION special
register into a host variable named CURXMLPARSEOPT:
EXEC SQL VALUES (CURRENT IMPLICIT XMLPARSE OPTION) INTO :CURXMLPARSEOPT;
- Set the CURRENT IMPLICIT XMLPARSE OPTION special register to 'PRESERVE
WHITESPACE'.
Whitespace is then preserved when the following SQL statement executes:SET CURRENT IMPLICIT XMLPARSE OPTION = 'PRESERVE WHITESPACE'
INSERT INTO T1 (XMLCOL1) VALUES (?)