Re: Overwriting existing data with sqlloader
From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Sat, 02 Oct 1999 14:59:09 -0500
Message-ID: <37F6640D.6FDD5E82_at_iquest.net>
Date: Sat, 02 Oct 1999 14:59:09 -0500
Message-ID: <37F6640D.6FDD5E82_at_iquest.net>
[Quoted] Not that we've found, at any rate. My workaround is to upload into a "temporary" table, then add a SQL UPDATE script to replace old rows from the intermediate source.
HTH,
Dave
Default wrote:
>
> I am try to use a cron job to load a table via sqlloader. Is there any
> way to overwrite the entire existing data with the new data.
>
> The loader control file is as follows .
>
> LOAD DATA
> INFILE 'bosscust.dat'
> INTO TABLE cust_country
> (customer_number POSITION(01:6) ,
> customer_desc POSITION(19:48),
> country_code POSITION(189:197) )
>
> regards,
> Alan Slattery
Received on Sat Oct 02 1999 - 21:59:09 CEST