SQLX options

binary

hex | base64

Representation of binary. Applies on to forxmlj.

columnstyle

element | attribute

Representation of SQL columns

entitize

yes | no | cond

forxmlj and for xml clause

format

yes | no

Include formatting

header

yes | no | encoding

Default value depends on the return type. See Chapter 6, “XML Support for I18N.”

Include the XML declaration

incremental

yes | no

Return a single row or multiple rows from a select statement that specifies for xml

multipleentitize

yes | no

forxmlmultiplej and for xml clause

nullstyle

attribute | omit

Representation of nulls with columnstyle=element

ncr

non_ascii | non_server | no

forxmlj and for xml clause

prefix

SQL name

Base for generated names. Default value is C.

root

yes | no

Include a root element for the table name

rowname

SQL name

Name of the row element.

Default value is row.

schemaloc

quoted string with a URI

schemalocation value

statement

yes | no

Include the SQL query

tablename

SQL name

Name of the root element. Default value is resultset.

targetns

quoted string with a URI

targetnamespace value (if any)

xsidecl

yes | no

forxmlj and for xml clause