Re: SQL*Loader error 524

I have seen this kind of error message before. Most likely it's the datafile (the "INFILE ..."). You should examine the log file to identify which row caused the trouble. Since you did not specify the log filename in the control file, the log filename will be "efft_index.log" (datafile name with the .log extension).

Bill West (wwest_at_ucsd.edu) wrote:
: Has anyone encountered an error of this type:

: SQL*Loader-524: partial record found at end of datafile (test.ctl)

: I am not sure this error refers to the data file or the control file since
: it mentions both. I use this utility frequently and this is the first time I
: encountered the error. It would seem to indicate some missing punctuation at
: the end of the control file but I can't see it. Below is the control file.

: LOAD DATA

: INFILE 'c:\temp\sdsc\efft_index.csv'

: BADFILE 'c:\temp\sdsc\efft_index.bad'

: DISCARDFILE 'c:\temp\sdsc\efft_index.dis'

: DISCARDMAX 999

: REPLACE
: INTO TABLE wwest.effective_index_master

: FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

: (ifis_index char,
: effective_date date "dd-Mon-yy",
: title char,
: fund char,
: org char,
: program char,
: refresh_date date "dd-Mon-yy",
: accting_period integer external)

: Any help would be greatly apprectiated.

: Bill West
: UCSD
Received on Thu Apr 15 1999 - 16:45:53 CDT