Filter
Top Products
4-60 IBM Informix OnLine Database Server Administrator’s Guide
Using UNLOAD with LOAD or dbload
Using UNLOAD with LOAD or dbload
This section describes the steps you take when you migrate data using either
of these two methods:
■ UNLOAD /dbschema /LOAD
■ UNLOAD /dbschema /dbload
Refer to page 4-53 for an overview of each method. Refer to the DB-Access
User’s Manual for instructions and syntax for UNLOAD and LOAD. Refer to
page 7-32 for instructions and syntax for dbschema. Refer to page 7-15 for
instructions and syntax for dbload.
Figure 4-14
Fourth
decision tree
summarizing the
choices among
OnLine migration
methods
How to choose between LOAD and dbload
Do you need to commit any inserts
during the load?
UNLOAD/
dbschema/
LOAD
Is the ASCII input file format
acceptable to LOAD?
UNLOAD/
dbschema/
dbload
Can you use sed, awk, or an
editor to easily reformat the
ASCII input files?
UNLOAD/dbschema/dbload
UNLOAD/
dbschema/
LOAD
No
No
No
Yes
Yes
Yes