1.1.1

[-user=<username>]
[-verbose=<level>]
This table describes options for the sqlf write-schema-to-xml command. Default values are used if you do not
specify an option.
DescriptionOption
The full path of the XML file to create. This argument is required.
-file
Sets the authentication provider to use for peer-to-peer connections
as well as client-server connections. Valid values are BUILTIN and
-auth-provider
LDAP. All other members of the SQLFire distributed system must
use the same authentication provider and user definitions. If you omit
this option, the connection uses no authentication mechanism. See
Configuring Authentication and Authorization on page 241.
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.
Specifies the type of database to which you are connecting. Use this
option if sqlf cannot determine the type of database from the JDBC
-database-type
driver and JDBC connection URL. Valid values are: axion,
cloudscape, db2, derby, firebird, hsqldb, interbase, maxdb, mckoi,
mssql, mysql, mysql5, oracle, oracle9, oracle10, postgresql, sapdb,
sqlfire, and sybase.
Specifies whether to use delimited (quoted) identifiers for table
names, column names, and so forth. Most databases convert
-delimited-identifiers
undelimited identifiers to uppercase letters and ignore any case that
you specify in the SQL command.
You can set this option to "true" for platforms that support delimited
identifiers. However, keep in mind that when you use delimited
identifiers, you must always enclose identifiers in double quotes, and
vFabric SQLFire User's Guide430
vFabric SQLFire Reference