DB2 database export

ILIAN_Grigorov · ‎2012 Mar 30

Hello all,

Currently we are using DB2 9.1,

its EXPORT command supports only 3 types of files - DEL, WSF, IXF

Is there any way I can export the database in other format - i.e. DBF...

Thanks

P.S. I remember some SAP migration tool had the ability to export the database

in some "database independant format" or smth. .....

Former Member · ‎2012 Mar 30

Hi,

usually IXF extension is used

and taking a look at IBM documentation it looks like the other extensions are not supported

Specifies the format of the data in the output file:

DEL (delimited ASCII format), which is used by a variety of database manager and file manager programs.
WSF (work sheet format), which is used by programs such as:Note:When exporting BIGINT or DECIMAL data, only values that fall within the range of type DOUBLE can be exported accurately. Although values that do not fall within this range are also exported, importing or loading these values back might result in incorrect data, depending on the operating system.
- Lotus 1-2-3
- Lotus Symphony
IXF (integrated exchange format, PC version), in which most of the table attributes, as well as any existing indexes, are saved in the IXF file, except when columns are specified in the SELECT statement. With this format, the table can be recreated, while with the other file formats, the table must already exist before data can be imported into it.

regards, Javier