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.