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
.-=-.
>>-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
- 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'