Need your help on this strange loading problem ... Thanks

Posted in 2006

Henry — 20 Sep 2006 18:14:29 -0700 — source: Usenet: comp.databases.informix

Hi all, I met with a strange problem. I have a script to load data from a text file into a table. On the first run, I hit with an error said that the number of columns mismatch. But, when I tried another time with the same source file, i received no error. Is there any explanation to this strange phenomenon? Error message: 846: Number of values in load file is not equal to number of columns. Thanks for your help.

↪ replying to Henry

Jonathan Leffler — Thu, 21 Sep 2006 03:42:40 GMT — source: Usenet: comp.databases.informix

Henry wrote: > I met with a strange problem. I have a script to load data from a text > file into a table. On the first run, I hit with an error said that the > number of columns mismatch. But, when I tried another time with the > same source file, i received no error. Is there any explanation to this > strange phenomenon? > > Error message: 846: Number of values in load file is not equal to > number of columns. Was the environment exactly the same? Specifically, could DBDELIMITER have been set one time and not the other? (What version? What platform?) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/