Hi I need to extract data from 8

[tonisyb]

Hi

I need to extract data from 800 tables on Sybase 11 and import it into corresponding tables on DB2. I'd like to use the import utility with the PC/IXF file format to avoid having to create each tables manually on DB2. However, I do not know how to bcp the data out from Sybase so that the file is in the above format.

I have issued the command below but DB2 returned an error message that the file was not a valid PC/IXF file
From the cmd line
CALL cmd_bcp dname, dbo, tablename, filename.ixf, user, password, server (which creates the filename.ixf)
From DB2
db2 import from filename.ixf of IXF create into table_name

Thanks

 

[Shaixpeare]

Hiyas,
You might want to download the DB2 Migration Kit from the IBM Website. It's free and it will convert Sybase 11 and SQL Server 6 & 7 database structures and data to DB2 UDB v 7.2. I recently used it on an extremely large SQL Server database and noticed that it supported Sybase 11 as well. Here is the link to download it:

http://www-3.ibm.com/software/data/db2/migration/mtk/

Enjoy!

Todd

 

[gregsimpson]

Hi,

I believe the IMPORT command will only work with the CREATE parameter if your IXF file was created by a DB2 EXPORT, this certainly used to be the case. When an IXF file is created using the DB2 EXPORT command, the table structure and definitions are stored in it.

In your case the IXF file was created by SYSBASE so won't hold the table information DB2 requires. I suggest you create the table first, remove the CREATE parameter from your command and then run it again.