Re: sqlldr - ignore columns?

From: Roel Toledo <rtoledo_at_worldnet.att.net>
Date: Thu, 31 Aug 2000 01:30:16 GMT
Message-ID: <Iyir5.11822$Q36.862001@bgtnsc07-news.ops.worldnet.att.net>

The Filler field is used basically like this:

LOAD DATA
INFILE *
INTO TABLE mytable
FIELDS TERINATED BY "," OPTIONALLY ENCLOSED BY '"' (Field1,
Field2,
Fillerfield1 FILLER,
Field3,
Field4)

The Fillerfield1 can be any name that you want. If you have multiple columns as filler you can name those columns as Fillerfield2 FILLER, Fillerfield3 FILLER, etc

Roel

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:39AA3E7B.34E9_at_yahoo.com...
> Russell England wrote:
> >
> > I have several csv files that I want to load, but the csv files
 have some
> > columns that I want to ignore:
> >
> > LOAD DATA
> > INFILE *
> > INTO TABLE mytable
> > FIELDS TERINATED BY "," OPTIONALLY ENCLOSED BY '"'
> > (Field1,Field2,,Field3,Field4)
> > BEGINDATA
> > "keep","keep","lose","keep","keep"
> > "keep","keep","lose","keep","keep"
> > ...
> >
> > How can I ignore the middle column?
> >
> > Thanks in advance
> >
> > Russ

>
> In 8i+ you can skip columns in SQL Loader - check the doco on the
 SKIP
> clause. In earlier versions, (if you are on unix), a little
 creative
> use with awk, cut et. al can modify the file before applying to
 sqlldr.

>

> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk

>
> We are born naked, wet and hungry...then things get worse
Received on Wed Aug 30 2000 - 20:30:16 CDT