Re: SQL*Loader Limitation?

I do have a CR at the end of control file. The problem is with partial data at the end of my data file. SQL*loader barfs on this.

IIFThen

<dogbert_at_myremarq.com> wrote in message news:uLNHuVT0#GA.324_at_nih2naaa.prod2.compuserve.com...
> Just a quick stab at your problem: make sure you have a carriage return at
> the end of the last line of your .ctl file.
>
> IIFThen <msessions_at_aldensys.com> wrote in message
> news:Jkkj3.9517$Tl3.72957_at_news3.mia...
> > Can SQL*Loader (used on NT server) handle partial records at the END of
 a
> > data file?
> >
> > SQL*Loader log file reports records successfully added but when I query
 the
> > data with SQL Worksheet it returns a count of 0. Can anyone out there
 try
> > inserting a character at the end of their datafile and then run
 SQL*Loader
> > against it. Then query to see if ALL non-partial records were loaded.
 For
> > me, 1) SQL*Loader reports Error 524: Partial records found at the end of
 the
> > data file, 2) SQL*Loader log file says that all records were
 successfully
> > loaded. 3) When I query the table, no records are there.
> >
> > I've already checked:
> >
> > * I looking at the right SQL*Loader file(timestamp, etc.)
> > * I used same schema parameters for both SQL*Loader and SQL Worksheet.
> >
> > I'm at a dead end on this one. I would appreciate any help.
> >
> > IIFThen
> >
> >
>
>
Received on Tue Jul 20 1999 - 00:00:00 CEST