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