See Example 6 6 for a simplified syntax diagram for the 

IMPORT

 command. For a 

complete syntax description please visit: 

http://www 306.ibm.com/cgi bin/db2www/data/db2/udb/winos2unix/support/v

8document.d2w/report?fn=r0008304.htm

Example 6 6   Simplified syntax of the DB2 IMPORT command

>> IMPORT FROM  filename  OF  filetype                          >

>  +                               +                            >

   |              .              . |

   |              V              | |

     MODIFIED BY    filetype mod +  

>  +                        +                                   >

     MESSAGES  message file  

>  + + INSERT         +  INTO  + table name  +                         + +  >

   | + INSERT_UPDATE  +        |             |    . ,             .    | |

   | + REPLACE        +        |             |    V               |    | |

   |   REPLACE_CREATE          |               (    insert column +  )   |

   |                             | hierarchy description |                

6.1.2  Differences in data formats

When migrating data from MySQL to DB2 UDB, specific data types require high 

attention. The 

DATETIME 

and 

TIMESTAMP

 data types have the same content in 

MySQL and DB2 UDB, but have a different representation. When loading the 

exported data into DB2 UDB you have to be aware of the data format.

Binary Large Objects

 (

BLOB

 data type) usually contain binary data. Exporting of 

binary data into text files is not possible. So, if your BLOBs contain binary data, 

you have to migrate them in a different way than exporting and loading.

MySQL DATETIME and TIMESTAMP data type format 

Both MySQL data types 

DATETIME 

and 

TIMESTAMP

are mapped to the DB2 data 

type 

TIMESTAMP

. So, exported MySQL application data of these types must be in 

a DB2 readable format.

The export format of MySQL 

DATETIME

 values is `

YYYY MM DD hh:mm:ss

', e.g. 

`

2004 01 30 14:21:14

'. Please notice the separators.

The export format of MySQL 

TIMESTAMP

 values is `

YYYYMMDDhhmmss

', without any 

separators between, such as `

20040130142114

'.

The DB2 

LOAD

 command lets you specify in the filetype modifier clause 

TIMESTAMPFORMAT

 how the format of 

TIMESTAMP

 values should be.

134 

MySQL to DB2 UDB Conversion Guide