1.1

Syntax
To write all table data from a database to an XML file, use the syntax:
sqlf write-data-to-xml -file=<path>
[-bind-address=<address>]
[-catalog-pattern=<pattern>]
[-client-bind-address=<address>]
[-client-port=<port>]
[-database-type=<db type>]
[-delimited-identifiers=<true | false>]
[-driver-class=<class name>]
[-exclude-table-filter=<filter>]
[-exclude-tables=<name,name,...>]
[-extra-conn-props=<properties>]
[-help]
[-include-table-filter=<filter>]
[-include-tables=<name,name,...>]
[-isolation-level=<level>]
[-locators=<adresses>]
[-mcast-address=<address>]
[-mcast-port=<port>]
[-password[=<password>]]
[-schema-pattern=<pattern>]
[-url=<url>]
[-user=<username>]
[-verbose=<level>]
This table describes options for the sqlf write-data-to-xml command. Default values are used if you do not specify
an option.
DescriptionOption
The full path of the XML file in which to write the table data. This
argument is required.
-file
The address to which this peer binds for receiving peer-to-peer
messages. By default sqlf uses the hostname, or localhost if the
hostname points to a local loopback address.
-bind-address
A string pattern that determines the database catalogs that sqlf writes.
sqlf does not use a default catalog pattern.
-catalog-pattern
To use a catalog pattern, specify a string value that describes the
catalogs that you want to write. Use the "%" character to match any
substring of 0 or more characters. Use the "_" character to match any
individual character.
The hostname or IP address on which a SQLFire locator listens for
client connections. The default is "localhost."
-client-bind-address
Use this option with -client-port to attach to a SQLFire
cluster as a thin client and perform the command.
The port on which a SQLFire locator listens for client connections.
The default is 1527.
-client-port
Use this option with -client-bind-address to attach
to a SQLFire cluster as a thin client and perform the command.
vFabric SQLFire User's Guide406
vFabric SQLFire Reference