1.1

[-extra-conn-props=<properties>]
[-help] [-locators=<addresses>]
[-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-db command. Default values are used if you do not specify
an option.
DescriptionOption
The full path to one or more data XML files that contain the data to
insert. Use a comma-separated list to specify multiple files. This
argument is required.
-files
See sqlf write-data-to-xml on page 405.
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 full path to one or more schema XML files to use when inserting
the data. Use a comma-separated list to specify multiple files. This
argument is required.
See sqlf write-schema-to-xml on page 417.
-schema-files
Specifies the maximum number of insert statements to combine in
a single batch. The default batch size is 1000 statements.
-batch-size
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
vFabric SQLFire User's Guide402
vFabric SQLFire Reference