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 diagramSETCURRENT IMPLICIT XMLPARSE OPTION=string-constanthost-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

  • The initial value of the CURRENT IMPLICIT XMLPARSE OPTION special register is 'STRIP WHITESPACE'.
  • Both dynamic and static SQL statements are affected by this special register.

Example

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