Re: sql loader problem

> 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
Received on Wed Sep 29 1999 - 11:31:04 CDT