The solidDB® Speed Loader is a tool for loading data from external files into a solidDB® database.
There are two variants of the solidDB® Speed Loader:
▪solloado provides support for Unicode and partial Unicode databases. It also enables loading of data with multiple threads. solloado is based on the solidDB® ODBC API; the client-side configuration parameters can be used to control the behavior of solloado.
▪solload provides support for partial Unicode databases only. solload is based on the solidDB® SA API.
The solidDB® Speed Loader can load data in various formats and produce detailed information of the loading process into a log file. The format of the import file, that is, the file containing the external data, is specified in a control file.
Key characteristics
▪The data is loaded into the database through the solidDB® engine. This enables online operation of the database during the loading.
▪The data to be loaded does not have to be located on the computer as the solidDB® server.
▪The data is loaded in batches. You can control the number of records committed in one batch.
▪The tables must exist in the database in order to perform data loading.
▪Catalogs are supported with the following syntax:
catalog_name.schema_name.table_name
▪The following constraints are checked:
– referential
– NOT NULL
– unique
▪solidDB® Speed Loader does not support check constraints that are defined using the CREATE TABLE and ALTER TABLE statement and specify data value restrictions in columns.
However, solidDB® Speed Loader always checks for unique or foreign key constraints that are defined using the CREATE TABLE statement.
Note The IBM Global Security Kit (GSKit) is not supported with solload connections. When using GSKit, use solloado.