Guidelines for Using dbload

This section includes the following guidelines for using the dbload utility:

• Termination of dbload
• Network names
• Simple large objects
• Indexes
• Delimited identifiers
• SE Example

Termination of dbload

If you press the Interrupt key, dbload terminates and discards any new rows that were inserted but not yet committed to the database (if the database has transactions).

Network Names

If you are on a network, include the database server name and directory path with the database name to specify a database on another database server or coserver.

Simple Large Objects

You can load simple large objects with the dbload utility as long as the simple large objects are in text files.

Indexes

The presence of indexes greatly affects the speed with which the dbload utility loads data. For best performance, drop any indexes on the tables that receive the data before you run dbload. You can create new indexes after dbload has finished.

Delimited Identifiers

You can use delimited identifiers with the dbload utility. The utility detects database objects that are keywords, mixed case, or have special characters, and places double quotes around them.

If your most recent dbload session ended prematurely, specify the starting line number in the command-line syntax to resume loading with the next record in the file.

Example

The following command loads data into the stores_demo database in the turku directory on the a database server called finland:

dbload -d //finland/turku/stores_demo -c commands -l errlog