DB2 10.5 for Linux, UNIX, and Windows

SET CURRENT IMPLICIT XMLPARSE OPTION statement

The SET CURRENT IMPLICIT XMLPARSE OPTION statement changes the value of the CURRENT IMPLICIT XMLPARSE OPTION special register.

This statement is not under transaction control.

Invocation

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.

Authorization

None required.

Syntax

Read syntax diagramSkip visual syntax diagram
                                          .-=-.   
>>-SET--CURRENT IMPLICIT XMLPARSE OPTION--+---+----------------->

>--+-string-constant-+-----------------------------------------><
   '-host-variable---'   

Description

string-constant
A character string constant. The value must be a left-aligned string that is either 'PRESERVE WHITESPACE' or 'STRIP WHITESPACE' (case insensitive) with no additional blank characters between the keywords.
host-variable
A variable of type CHAR or VARCHAR. The value of the host variable must be a left-aligned string that is either 'PRESERVE WHITESPACE' or 'STRIP WHITESPACE' (case insensitive) with no additional blank characters between the keywords. The value must be padded on the right with blanks when using a fixed-length character host-variable. The host variable cannot be set to null.

Notes

Example

Set the value of the CURRENT IMPLICIT XMLPARSE OPTION special register to 'PRESERVE WHITESPACE'.
   SET CURRENT IMPLICIT XMLPARSE OPTION = 'PRESERVE WHITESPACE'