Please unsubscribe me
-----Original Message-----
From: Arun Shastry <arun@^*^*^*^*.com>
To: informix-list@iiug.org <informix-list@iiug.org>
Date: Monday, April 05, 1999 12:27 PM
Subject: Re: Bizarre Errors using dbaccess to load data
>Check if your data itself has the delimiter character '|'. That would
throw off
>
>the columns while loading. If you do, then you may have to load the data
into
>temporary staging tables and then load them to the production tables using
>concatenation and inserts.
>
>To circumvent this issue, set the DBDELIMITER to something other than '|';
I've
>always used '^' and it's safer.
>
>Good luck,
>Arun
>
>MB wrote:
>
>> These errrors I cannot understand .....
>>
>> Just upgrading from 7.2 to 7.3
>>
>> For safety did dbexport from 7.2
>>
>> Used dbimport to get unl files into 7.3.
>>
>> Most load without a problem .... It looks like the big ones have a
problem
>> (not always but mostly)
>>
>> Out of 47 tables 5 would not load via dbimport giving Number of values
not
>> matching columns.
>>
>> So I loaded removed these 5 from the dbimport sql file and loaded all OK.
>>
>> After I used dbaccess to load them using as an example the following
>>
>> load from 'conta00159.unl' delimiter '|' insert into contacts>>
>> Would load approx 6-7000 records (130,000 total) and bomb out with either
>> character to numeric conversion OR
>> number of values in load file not equal error.
>>
>> SO - I checked the file - everything was Okay so I
>> Deleted the lines that had already been loaded and restarted the process
>> with the same file
>> but the so called error line now as line 1.
>>
>> Load process would then continue without a problem for another 6-7000
>> records,
>> and sure enough would fall over again......I repeated the process of
>> deleting the loaded lines
>> and restarted ....
>>
>> Is there a size setting or something that I'm hitting that would cause
these
>> weird errors because
>> there is absolutely nothing wrong with the file ...
>>
>> Your comments and advice would be welcome, as you can imagine this load
is
>> taking all Easter Monday
>> to complete !!
>>
>> And no the data does not have any | signs in there....
>>
>> Either reply to group or direct to mikeb@terratech.co.uk...
>>
>> Thanks in advance :-)
>