WI121: Can't import data file `filename` into table `tablename` because data file has `number` columns but table has `number` columns.

The source file and the target table in your Import operation do not have the same number of fields. If you are running a batch import, verify that the TABLE statement in the IMP file is set to the correct target table. Also verify that the FIELDS, TYPES, NULL_PERM, SRC_LENS, OFFSETS, USE_PIC and EBCDIC_TO_ASCII statements in your IMP file reflect the actual number of columns in your source and destination. See your SQLWizard User's Guide for a complete description of the IMP file and its contents.

Send feedback about this topic

WI121: Can't import data file filename into table tablename because data file has number columns but table has number columns.

WI121: Can't import data file `filename` into table `tablename` because data file has `number` columns but table has `number` columns.