Hi all,

I am trying to copy data from one database to another database to an existing table -- (same instance and table names of the source and target are the same). It says table already exists and doesnt copy the data. Please help.

I am running DB2 8.1.5 on Windows 2000

Code:

CONNECT TO DBTEST1 Administrator USING ****;
EXPORT TO \\DB2WIN2000\C$\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF OF IXF MESSAGES \\DB2WIN2000\C$\PROGRA~1\IBM\SQLLIB\WEBCPTAB.EXM SELECT * FROM DBO.TESTDATA;

CONNECT TO DBTEST2 USER Administrator USING ****;
IMPORT FROM \\DB2WIN2000\C$\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF OF IXF MESSAGES \\DB2WIN2000\C$\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IMM INSERT INTO DPS.TESTDATA;
CONNECT RESET;


Thanks in advance.

Newbie

Does look correct to me ..

Can you check the message log and post the full message here?

Sathyaram

The number of columns did not match. That was why i got the error. Thanks.