IBM 000-8697 User Manual

Utilities

The -i option instructs dbload to read and ignore the specified number of

NEWLINE

characters in the input file before it begins processing. (This option

assumes that a

NEWLINE

 character indicates the end of an individual data

row and header information.)

This option is useful if your most recent dbload session ended prematurely.
If, for example, dbload ended after inserting 240 lines of input, you can
resume loading at line 241 by setting number rows ignore equal to 240. It is also
useful if header information in the input file precedes the data records.

If your database supports transactions, dbload commits a transaction after
every specified number of new rows are read and inserted. A message is
displayed after each commit.

If you do not specify the -n option, dbload commits a transaction after every
100 rows are inserted.

For information about transactions, see

instructs dbload to execute a commit after the
specified number of new rows are inserted.

-n number inserted rows

Batch

Size