Re: Problems with LOAD

In article <7kt2su$2pk$1@nnrp1.deja.com>, justerman@my-deja.com wrote: > I have a mysterious problem with LOAD clause. > > I have a file test.txt which has about twenty columns float numbers > divided by tabs. I would like to copy this table to my database. Table > at database have alltough more columns than my file. This is because I > want to forexample create a serial number for each row with informix. > > LOAD FROM 'path\\file' DELIMITER '<ctrl-i>' INSERT INTO> testtable(col2,col3,col4,col5,etc); If the first column of your testtable is a serial number, try this: LOAD FROM 'path\\file' DELIMITER '<ctrl-i>' INSERT INTOtesttable(0,col2,col3,col4,col5,etc); > > After executing these following messages appeared: > > Error in load file line1 > Number of values in load file is not equal to number of columns > > This is quite weird, because i wrote a test file where I had less > columns than in my table, and no problems occured... > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.