Re: dbload

> > Help! > > I am trying to dbload a table with 78 fields. (The table does have > 78 fields, my ascii text has 78 fields, the dbload commands say 78) > but I am getting the error : > > Number of values given does not match number of columns > > > (I have tried using delimiter ',' as well as | ) > > Now the only thing I can think of is that each record (ie line) is > approx 700 char in length. Is this breaking the INSERT? > > I do have the trailing delimiter on the end of each line... > > Alex McLintock [also alexmc@biccdc.co.uk] > Hi, What I feel is may be there is an extra space at the end of each row in your ASCII File. Having this will also lead U to the Problem. Check your ASCII File and try to load few rows ( 5 Rows ), since error examine for the last space in the row ( after last delimiter ). I had encountered this problem for having an extra space after the last delimiter in each row which prompted error. Rgds, Chetan Anand DH INTERNATIONAL (Singapore) PTE LTD Singapore e-mail : anand@sin-co.sin-ro.dhl.com