Figure 8 4   Export using control centre

An application programming interface (API)

DB2 UDB provides an API for exporting data, which can be used to export 

data programmatically. This can be used by importing 

sqlutil.h

 and the 

method 

sqluexpr

.

The IMPORT utility

The files created by 

EXPORT

 utility can be used to populate data into a new DB2 

UDB database on the same system, or they can be transferred to another 

workstation platform and imported or loaded to a DB2 database that resides on 

that platform. IMPORT utility supports the following file formats:

ASC: non delimited ASCII format file

.DEL: delimited ASCI format file

.WSF: work sheet format like lotus 1 2 3

.IXF: integrated exchange format

As 

EXPORT

, 

IMPORT

 utility can also be used from:

The Command line processor (CLP)

244 

MySQL to DB2 UDB Conversion Guide