Option values for query functions.

binary

hex | base64

for xml clause

columnstyle

element | attribute

for xml clause

dtdvalidate

yes | no

xmlvalidate

entitize

yes | no | conditional

for xml clause

format

yes | no

for xml clause

header

yes | no |encoding

for xml clause

nonamespaceschemalocation

See xmlvalidate

xmlvalidate

ncr

non_ascii | non_server | no See function description for default value.

for xml clause, xmlextract

nullstyle

attribute | omit

for xml clause

prefix

SQL name (C)

The default value is C.

for xml clause

root

yes | no

for xml clause

rowname

SQL name (row)

for xml clause

schemalocation

See xmlvalidate

for xml clause

schemavalidate

yes | no

xmlvalidate

statement

yes | no

forxml clause

tablename

SQL name (resultset)

for xml clause

targetns

quoted string with a URI

for xml clause

xmlerror

exception | null | message

all functions with XML operands

xmlvalid

document | message

xmlvalidate

xsidecl

yes | no

for xml clause