4-60 IBM Informix OnLine Database Server Administrator’s Guide

Using UNLOAD with LOAD or dbload

Using UNLOAD with LOAD or dbload
Thissection describes the steps you take when you migrate data using either
of these two methods:
UNLOAD /dbschema/LOAD
UNLOAD /dbschema/dbload
Refer topage 4-53 for an overview of each method. Refer to the DB-Access
User’sManual for instructions and syntax for UNLOAD and LOAD. Refer to
page 7-32 for instructions and syntax fordbschema. Refer to page7-15 for
instructions and syntax fordbload.
Figure4-14
Fourth
decision tree
summarizing the
choices among
OnLine migration
methods
How to choose between LOAD and dbload
Doyou 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