Administrator Guide : Using solidDB® data management tools : solidDB® Speed Loader (solloado and solload) : Starting solidDB® Speed Loader (solloado and solload)
  
Starting solidDB® Speed Loader (solloado and solload)
Start solidDB® Speed Loader with the command solloado or solload, followed by argument options.
If you start solidDB® Speed Loader with no arguments, you see a summary of the arguments with a brief description of their usage.
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 options can be:
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
Change working directory
-C catalogname
X
X
Set the default catalog from where data is read from or written to
-l filename
X
X
Write log entries to this file
-L filename
X
X
Append 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’s 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’s 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
Insert array size (network version)
-s schema_name
X
X
Set the default schema
-t
X
X
Print 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
Help = Usage
-x emptytable
X
X
Load 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
Read 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 also
solidDB® Speed Loader (solloado and solload)