Filter
Top Products
Utilities 7-19
Batch Size
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.
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.
If you do not specify the -n option, dbload commits a transaction after every
100 rows are inserted.
For information about transactions, see IBM Informix Guide to SQL: Tutorial.
-n number inserted rows instructs dbload to execute a commit after the
specified number of new rows are inserted.
-n number inserted rows
Batch
Size