SQLX options

NoteIn Table 5-1, underlined words specify the default value.

Table 5-1: Options for SQLX mappings

Option name

Option value

Function

binary

hex | base64

Representation of binary. Applies on to forxmlj.

columnstyle

element | attribute

Representation of SQL columns

format

yes | no

Include formatting

header

yes | no

Include the XML declaration

incremental

yes | no

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

nullstyle

attribute | omit

Representation of nulls with columnstyle=element

prefix

SQL name

Base for generated names

root

yes | no

Include a root element for the table name

rowname

SQL name

Name of the row element

schemaloc

quoted string with a URL

schemalocation value

statement

yes | no

Include the SQL query

tablename

SQL name

Name of the root element

targetns

quoted string with a URL

targetnamespace value (if any)