Re: SQL Loader

Bernd Dormann wrote:
>
> Probably there is an unvisible "End of File" Sign in your file. This
> happens when you transfer files between different operating systems.
>
> Bye
>
> Bernd
>
> maui_jenne wrote:
> >
> > I keep getting the error message:
> >
> > SQL*Loader-524: partial record found at end of datafile (loader.ctl)
> >
> > Here is the loader.ctl: any suggestions?
> > I tested the d.dat file with only one record.. still nothing.
> > I tried with both a ; and the end of the record and without in the d.dat
> > file
> >
> > LOAD DATA
> > INFILE d.dat
> > INTO TABLE test
> > INSERT
> > FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '" "'
> > (DR_ID,TITLE,CLASSIFICATION,DESCRIPTION,REPORTED_BY,TEST_CASE_ID,DATE_TI
> > ME,TEST_ENVIRONMENT,ASSIGNED_TO,WHEN_FIXED_DATE,,STATUS,OPENNED)
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

We had this problem with a version of SQL*Loader, and it appeared to be 1)a missing, or 2)an extra, Carriage-Return at the end of the Control file (I cannot remember which).

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Jan 14 2000 - 01:39:11 CET