1.1

DescriptionOption
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
you must specify the correct case for the identifier in all subsequent
SQL commands.
By default, sqlf sets this option to "false."
The JDBC driver class to use for connecting to a datasource. Use
this option with -url to connect to a JDBC datasource.
-driver-class
Specifies whether the ordering of foreign keys is honored during the
data import. Set this option to "false" if all of the referenced rows
-ensure-fk-order
come before referencing rows in the data XML file. (Or, change the
order for inserting rows to otherwise preserve the foreign key order.)
With the default value of "true," sqlf delays inserting referenced rows
until referencing rows are first inserted. This process consumes
memory reduces import performance, so large datasets should
preserve foreign key ordering in the XML file when possible.
403
sqlf Launcher Commands