The IMPORT utility can be used from CLP by supplying an SQL 

INSERT, 

INSERT UPDATE, REPLACE

 or

 REPLAE_CREATE

 option. Also you can import the 

table hierarchy using the 

CREATE INTO

 option. The example below shows the 

simple IMPORT statement:

db2>import from itso.ixf of ixf messages msg.txt insert into itsodb.katalog

The Control Center

Control Center can be used for importing data visually. You can get a wizard 

shown in Figure 8 5 by right clicking

 and selecting

 Import... 

from

the 

System  > server name  > Instance  > Databases  > database 

name  > Tables 

window.

Figure 8 5   Import using control center

An application programming interface (API)

 Chapter 8. Database administration 

245