Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Angry Unanswered: import/export db2 table

    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.

  2. #2
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Re: import/export db2 table

    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

  3. #3
    Join Date
    Jun 2003
    Posts
    77

    Re: import/export db2 table

    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.



    Originally posted by qxz
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •