1.1.1

[-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 416.
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.
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 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 429.
-schema-files
Specifies the maximum number of insert statements to combine in
a single batch. The default batch size is 1000 statements.
-batch-size
413
sqlf Launcher Commands