EXPORT utility

DB2 

EXPORT

 is a powerful tool to export your DB2 data quickly from DB2 UDB to 

one of the file system outside DB2 system. DB2 

EXPORT

 can be used to export 

tables, views, large objects, or typed tables to one of the three external file 

formats:

.DEL: delimited ASCII format file

.WSF: work sheet format like lotus 1 2 3 

.IXF: integrated exchange format

The EXPORT utility can be invoked through:

The Command Line Processor (CLP)

The 

EXPORT

 utility can be used from CLP by supplying an SQL SELECT 

statement, or by providing hierarchical information for typed tables as shown 

below:

db2>export to itos.ixf of ixf select * from itsodb.katalog

The Control Center

DB2 UDB data can be exported using a graphical user interface, which allows 

you to set export options for each table visually from Control Center. 

Figure 8 4 shows the usage of export through Control Center.

 Chapter 8. Database administration 

243