Utilities 7-19

Batch Size

The -i option instructsdbload to read and ignore the specified number of
NEWLINEcharacters in the input file before it begins processing. (This option
assumes that aNEWLINE character indicates the end of an individual data
row and header information.)
This option is useful if your most recentdbload session ended prematurely.
If, for example,dbload ended after inserting 240 lines of input, you can
resumeloading 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.
Batch Size
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.
Ifyou do not specify the -n option, dbload commits a transaction after every
100 rows are inserted.
For information about transactions, seeIBM I nformix Guide to SQL: Tutorial.
-n number inserted rows instructsdbload to execute a commit after the
specified number of new rows are inserted.
-nnumber inserted rows
Batch
Size