Re: sqlldr - ignore columns?

From: Yong Huang <yhuang_at_indigopool.com>
Date: Mon, 28 Aug 2000 13:35:01 -0500
Message-ID: <8oebir$psi$1@news.sinet.slb.com>

I made the same mistake in believing so. SKIP is for skipping rows (records as sqlldr calls), not columns.

Yong Huang
yhuang_at_indigopool.com

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 Mon Aug 28 2000 - 13:35:01 CDT