Search code examples
sqlloadinformix

Number of values in load file is not equal to number of columns

I delete some data by wrong and i want to retrieve them

I try to execute the following command :

LOAD FROM 'C:\db\rqrequesttrans.dat' delimiter '~' insert into rqrequesttrans

but i get the following error :

-- [Informix][Dynamic Server plus Universal Data Option][arch] SQL Error (-847) : Error in load file line 220.
-- [Informix][Dynamic Server plus Universal Data Option][arch] SQL Error (-846) : Number of values in load file is not equal to number of columns.

How to fix this problem ?

Solution

  • There's a different number of data columns in the file than in the schema of the table for row 220. Make sure row 220 has the right number of delimiters for your table.

    I don't how many rows in your data table but check to make sure the file is complete.