Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2005

    Unanswered: Importing GRAPHIC datatypes

    I'm trying to import tables exported from DB2 on AS/400 in ixf format via DB2 Connect into DB2 V7 FP13 on Windows 2000 Server. The command I am using is,

    IMPORT FROM import_file.ixf OF IXF MODIFIED BY forcein nochecklengths indexschema=ADMINISTRATOR MESSAGES errors.txt INSERT INTO some.table;

    And generates the following error:
    SQL3157W The type field in the C record for column "DISPLAYNAME
    " is not valid. Data from the column will not be loaded.

    The database uses UTF-8 character set. I created the target table with the same fields and datatypes as the export table.
    Last edited by dgerlach; 02-04-05 at 20:00.

Posting Permissions

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