1.1

[-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-schema-to-db command. Default values are used if you do not
specify an option.
DescriptionOption
The full path to one or more schema XML files to use for creating
the schema. Use a comma-separated list to specify multiple files.
This argument is required.
-files
This option is provided for tables that have GENERATED ALWAYS
identity columns, which prohibit manually inserting identity values
-alter-identity-columns
even during data import. If one or more tables contains existing
GENERATED ALWAYS identity values that you want to preserve,
specify -alter-identity-columns with both the sqlf write-schema-to-db
and sqlf write-data-to-db commands.
When you include this option with sqlf write-schema-to-db, SQLFire
changes an existing GENERATED ALWAYS identity column to a
non-identity column. This enables you to import existing data values
for the column.
When you include this option with sqlf write-data-to-db, SQLFire
alters the column to an identity column (GENERATED ALWAYS
AS IDENTITY) after the final column value is imported. Identity
values are then automatically generated for new rows, and SQLFire
ensures that all new identity values are greater than the last imported
value.
As an alternative to using these options, SQLFire supports
GENERATED BY DEFAULT identity columns that permit insertion
of the identity value. See Identity ColumnsGENERATED ALWAYS
Identity ColumnsGENERATED BY DEFAULT Identity Columns
in the CREATE TABLE reference page.
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
vFabric SQLFire User's Guide410
vFabric SQLFire Reference