Underlining indicates the default values of options that
specify keywords in this table. Parentheses show the default values
of options specifying SQL names. The empty string,
or a single-space character, specifies the default values of options specifying
string values.
Table 2-3: Option string values
Option name
|
Option value
|
Function
|
|---|
binary
|
hex | base64
|
forxmlj and for
xml clause
|
columnstyle
|
element | attribute
|
forxmlj and for
xml clause
|
dtdvalidate
|
yes | no
|
xmlvalidate
|
entitize
|
yes | no | conditional
|
forxmlj and for
xml clause
|
format
|
yes | no
|
forxmlj and for
xml clause
|
header
|
yes | no |encoding
|
forxmlj and for
xml clause
|
incremental
|
yes | no
|
for xmlj clause
|
nonamespaceschemalocation
|
See xmlvalidate
|
xmlvalidate
|
ncr
|
non_ascii | non_server | no
See function description for default value.
|
forxmlj, for
xml clause, xmlextract
|
nullstyle
|
attribute | omit
|
forxmlj and for
xml clause
|
nullclause
|
null | empty
|
forsqlcreatej
forsqlscriptj
|
prefix
|
SQL name (C)
The default value is C.
|
forxmlj and for
xml clause
|
root
|
yes | no
|
forxmlj and for
xml clause
|
rowname
|
SQL name (row)
|
forxmlj and for
xml clause
|
schemalocation
|
See xmlvalidate
|
forxmlj and for
xml clause
|
schemavalidate
|
yes | no
|
xmlvalidate
|
statement
|
yes | no
|
for xmlj and forxml clause
|
tablename
|
SQL name (resultset)
|
forxmlj and for
xml clause
|
targetns
|
quoted string with a URI
|
forxmlj and for
xml clause
|
xmlerror
|
exception | null | message
|
all functions with XML operands
|
xmlvalid
|
document | message
|
xmlvalidate
|
xsidecl
|
yes | no
|
forxmlj and for
xml clause
|
