We are using DB2 V5 in MS Win NT. I export a table to a.ixf file in the
DB2 control center, and in the command center in other workstation I execute:

import from a.ixf of ixf messages a.log create into a

I got the error:

SQL3310N Column " " in the PC/IXF file is not valid.

What could be the reason for such a simple operation? It doesn't happen to other tables that are imported/exported in this way!

Thanks.

Hi this might be beczuse the importing table and exported table may not be fo the same structure.

Describe both tables.Check for each field.

Still if it does not work try to copy the target table to the target database.u can use copy in control center.

hope it should work

mickykt

I got the same error in importing a table. In my case, the sequence of columns were different in importing and exporting tables. I created a new table with the same sequence and then the import worked.
So, check the order(sequence) of columns in the two tables.
It might help.