Re: sql loader problem

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Wed, 29 Sep 1999 19:29:58 GMT
Message-ID: <7stpb4$ibt$1@nnrp1.deja.com>

Specify
INFILE '091399.txt'
in your control file after
LOAD DATA ex:

LOAD DATA
INFILE '091399.txt'
REPLACE

...
...
...

-Anil

In article <37F23BC7.7E68F4E2_at_creditwatch-inc.com>, Brian Howard <bh_at_creditwatch-inc.com> wrote:
> > the control file looks like the following:
> >
> > LOAD DATA
> > REPLACE
> > INTO TABLE QUANAYA.LOADER
> > FIELDS TERMINATED BY " "
> > TRAILING NULLCOLS
> > (
> > BILL_NR CHAR,
> > CURR_AMT_DUE DECIMAL EXTERNAL,
> > CUST_NM CHAR,
> > DELINQ_AMT_DUE DECIMAL EXTERNAL,
> > ST_CD CHAR,
> > TN_EFF_DT DATE "YYMMDD"
> > )
>
> "Lars Sjöström" wrote:
>
> > What is in the ctl-file?
> > Is it a valid SQLloader control file? If it is, maybe it is not
ended with a
> > return or something.
> >
> > SQLLoader always needs a control file.
> >
> > Lars
> > Linköping
>
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 14:29:58 CDT