7-16 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
The dbload syntax and use information begins in the next section. The
dbload command 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 (see page 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
You can 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 installed IBM Informix
STAR.
If you specify part (but not all) of the required information, dbload prompts
you for additional specifications. After you enter additional specifications or
press RETURN to accept the default values that appear in the prompts, the
screen is cleared and dbload begins execution.
-c command file specifies the filename or pathname of a dbload command
file.
-d database specifies the name of the database to receive the data.
-l error log file specifies the filename or pathname of an error log file.
-r instructs dbloadto 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
-d database -c command file -l error log file
