IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

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

. After you create the command file, you can use the -s

option (see

) to check the syntax of the statements within the

command file.

You can display the software version number by executing dbload -V.

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 I

nformix

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.

specifies the filename or pathname of a dbload command
file.

specifies the name of the database to receive the data.

specifies the filename or pathname of an error log file.

instructs dbload to allow other users to modify data in the
table during the load (do not lock the table during the
load).

Batch Size

p.

Bad-Row

Limits

p.

-r

dbload

Starting

Line No.

p.

Command-File

Syntax Check

p.

-d database -c command file -l error log file