7-16 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
The dbload syntax and use information begins in the next section. The
dbloadcommand file structure and instructions for creating a command file
begin on page 7-21. After you create the command file, you can use the-s
option (seepage 7-18) to check the syntax of the statements within the
command file.
You can display the software version number by executing dbload -V.
Syntax
Youcan use the OnLine syntax database@dbservername to specify the database.
Specifying a database server name allows you to choose a database on
another server as your current database if you have installedIBM Informix
STAR.
Ifyou specify part (but not all) of the required information, dbload prompts
youfor additional specifications. After you enter additional specifications or
pressRETURN to accept the default values that appear in the prompts, the
screen is cleared anddbload begins execution.
-ccommand file specifiesthe filename or pathname of a dbload command
file.
-d database specifies the name of the database to receive the data.
-lerror log file specifies the filename or pathname of an error log file.
-r instructsdbload to allow other users to modify data in the
table during the load (do not lock the table during the
load).
Batch Size
p. 7-19 Bad-Row
Limits
p. 7-20
-r
dbload
Starting
Line No.
p. 7-18
Command-File
Syntax Check
p. 7-18
-ddatabase -c command file -l error log file