Re: append records from flatfile via SQLLDR ?

Hi.

 Try :

 LOAD DATA
   INFILE '/dbraid/ida1-00/home/applmgr/fixed_assets.dat' APPEND    INTO TABLE apps.fixed_assets

 HTH. Michael

In article <8k6bq0$n65$1_at_nnrp1.deja.com>,   Susie Grace <hlng_at_usa.net> wrote:
> how does one append records from a flat file to an existing file that
 is
> already populated using SQLLDR?
>
> I know the syntax for INSERTING records into a BLANK table:
>
> LOAD DATA
> INFILE '/dbraid/ida1-00/home/applmgr/fixed_assets.dat'
> INTO TABLE apps.fixed_assets
> (
> dept INTEGER EXTERNAL TERMINATED BY ',' ,
> asset_no INTEGER EXTERNAL TERMINATED BY ',' ,
> description CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED
 BY '"',
> in_service DATE "DD-MON-RR" TERMINATED BY ',' ,
> method CHAR TERMINATED BY ',' ,
> yr_mo DECIMAL EXTERNAL TERMINATED BY ',' ,
> cost DECIMAL EXTERNAL TERMINATED BY ',' ,
> amount DECIMAL EXTERNAL TERMINATED BY ',' ,
> depreciation DECIMAL EXTERNAL TERMINATED BY ',' ,
> reserve DECIMAL EXTERNAL TERMINATED BY ',' ,
> percent DECIMAL EXTERNAL TERMINATED BY ',' ,
> t_f CHAR
> )
>
> but how can I modify this so that additional files can be processed
> later? Thanks, and sorry for the wordiness.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 08 2000 - 00:00:00 CDT