Download In This Chapter

LOAD, UNLOAD, and dbload
Database Server Options
The dbimport utility supports the following options for a new Informix
database server (except SE):
SE
■
Create an ANSI-compliant database (includes unbuffered logging).
■
Establish transaction logging for a database (unbuffered or buffered
logging).
■
Specify the dbspace where the database will reside.
SE Options
The dbimport utility supports the following options for a new SE database:
■
Create an ANSI-compliant database (ANSI-compliant logging).
■
Establish transaction logging for a database (unbuffered logging).
LOAD, UNLOAD, and dbload
The LOAD statement is moderately fast and easy to use, but it can only accept
specified data formats. You usually use LOAD with data that is prepared with
an UNLOAD statement.
You can use the UNLOAD statement in DB-Access to unload selected rows
from a table into a text file.
To load tables, use LOAD or dbload. To manipulate a data file that you are
loading or to access a database while it is loading, use the dbload utility. The
cost of the flexibility is the time you spend creating the dbload command file
and slower execution. When possible, use the LOAD statement, which is
faster than dbload. Figure 2-4 summarizes questions to help you choose
among these methods.
Data Migration 2-15