solidDB Help : solidDB reference : Command line options : solidDB Speed Loader (solloado or solload) command line syntax
  
solidDB Speed Loader (solloado or solload) command line syntax
Start solidDB Speed Loader with the command solloado or solload, followed by argument options. For information about using solloado and solload, see solidDB Speed Loader (solloado and solload).
The syntax for starting solloado is:
solloado [options] [network_name] username [password] control_file
The syntax for starting solload is:
solload [options] [network_name] username [password] control_file
where:
▪ network_name is the network name of a solidDB server that you are connected to, see Network listening names (Com.Listen). The given network name must be enclosed in quotation marks. Logical data source names can also be used with the solidDB tools.
If you are using solloado to connect to a solidDB grid, include grid in the network name, for example:
solloado "grid tcp myhost1 1964" dba dba fixed.ctr
For more information, see Connecting to a grid.
Note Some built-in functions listed below are derived from ODBC standards instead of SQL standards. Please be aware that there may be some incompatibilities with certain built-in functions.
▪ username is required to identify the user and to determine the authorization level of the user authorization. Without appropriate rights, command execution is denied.
▪ password is the password of the user for accessing the database. The password is mandatory, if the password is not read from a file (defined with option -x pwdfile: filename), or optional, if the password is read from a file.
If the username and password are specified at the command line, the network_name must also be specified.
▪ control_file is the name of the control file, see Control file.
▪ options are described in the following table:
 
Option syntax
solloado
solload
Description
-b statements
X
X
Number of insert statements to commit in one batch (number of statements after which commit is executed)
For example, if you specify -b 10, commit is executed after 10 inserts.
-B records
X
 
Number of records to be inserted in 1 statement
For example, if you specify -B 3, each insert inserts 3 rows.
-c dir
X
X
Changes working directory
-C catalogname
X
X
Sets the default catalog from where data is read from or written to
-l filename
X
X
Writes log entries to this file
-L filename
X
X
Appends log entries to this file
-m
X
 
▪ In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the console locale/codepage, despite the settings in the server-side and client-side character data binding parameters.
▪ In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the console locale/codepage, despite the settings in the server-side and client-side character data binding parameters. Data in character data type columns is not converted.
See Using solidDB tools with Unicode for more information.
-M locale_name
X
 
▪ In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the specified locale/codepage.
▪ In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the specified locale/codepage. Data in character data type columns is not converted.
The format of locale_name depends on the operating system.
For example, in Linux environments, the locale name for the code page GB18030 in Chinese/China is zh_CN.gb18030.
In Windows environments, the locale name for Latin1 code page in Finnish/Finland is fin_fin.1252.
See Using solidDB tools with Unicode for more information.
-u
X
 
▪ In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in UTF-8.
▪ In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in UTF-8. Data in character data type columns is not converted.
See Using solidDB tools with Unicode for more information.
-n records
X
X
Inserts array size (network version)
-s schema_name
X
X
Sets the default schema
-t
X
X
Prints load time
-w threads
X
 
Sets the number of threads inserting data. The value cannot exceed the number of processors. Default is 4.
-h
X
X
Displays command usage
-x emptytable
X
X
Loads data only if there are no rows in the table
-x errors:count
X
X
Maximum error count
-x nointegrity
X
X
No integrity checks during load
-x pwdfile:filename
X
X
Reads password from the file
-x skip:records
X
X
Number of records to skip
-x utf8
 
X
WCHAR data is in UTF-8 format
See
solidDB Speed Loader control file syntax
Go up to
Command line options