IBM 000-8697 Manual Do Utilizador

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

for an overview of each method. Refer to the

ccess

ser’s

anual for instructions and syntax for UNLOAD and LOAD. Refer to

for instructions and syntax for dbschema. Refer to

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

Yes