Re: SQL*LOADER-524 ERROR MESSAGE

I run all of my control files thru OEM's Data Manager which might make a difference, but none of mine end with a semi-colon. Hope that helps.

Linda Dickert wrote:

> I have created a data file from our vax-vms mainframe, ftp'd it to the
> database server, and I am attempting to insert the vax data into an
> Oracle db file that I created a sql and a ctl file for.
> I issued the request from a batch file on the server using this command:
>
> c:\orant\bin\sqlldr80.exe ldickert/ldickert
> c:\updates\FTPSTUFF\PERSONAL_DATA.ctl
>
> This command has always worked; however, this time I receive an
> SQL*Loader-524 error message: partial record found at end of datafile
> (c:\updates\ftpstuff\personal_data.ctl). This message is not in the
> Oracle error message on-line help.
>
> This is a copy of my control file: (I created the positions by pulling
> the ftp'd data file into DOS and counting each position.)
> LOAD DATA INFILE "C:\INETPUB\FTPROOT\PERSONAL_DATA.DAT"
> INTO TABLE STUDENT.PERSONAL_DATA
> (
> STUD_ID POSITION (1:9),
> STUD_TITLE POSITION (11:14),
> STUD_LAST_NAME POSITION (16:30),
> STUD_FIRST_NAME POSITION (32:46),
> SP_STUD_STREET1 POSITION (48:72),
> SP_STUD_CITY POSITION (81:100),
> SP_STUD_STATE POSITION (102:103),
> SP_STUD_ZIP POSITION (106:110),
> SP_STUD_PHONE POSITION (112:123),
> STUD_BIRTH_YY POSITION (125:128),
> STUD_RACE POSITION (130:130),
> STUD_SEX POSITION (132:132),
> STUD_TOT_Q_S_GPA POSITION (135:138),
> STUD_GRADE_I_FLAG POSITION (140:140),
> CURR_CODE POSITION (143:147),
> GRD_STATUS POSITION (149:149),
> GRD_PROGRAM_TYPE POSITION (151:151),
> GRD_CAMPUS_CODE POSITION (154:155),
> GRD_TERM_YY POSITION (162:165),
> GRD_TERM_Q POSITION (168:168))
> ;
>
> I run the database on NT 4.0 (service pack 3) 256K memory-- 12Gig hard
> drive
>
> Any help will be appreciated!
>
> ----------------------------------------------------------------------
>
> Linda Dickert <ldickert_at_tcl.tec.sc.us>
> Oracle Database Manager
> TCL
>
> Linda Dickert
> Oracle Database Manager <ldickert_at_tcl.tec.sc.us>
> TCL
> PO 1288 921 Ribaut Road;Beaufort;SC;29920;USA Fax: 1-843-525-8330
> Home: 1-843-838-5643
> Work: 1-843-525-8212
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Dickert
> First Name Linda
> Version 2.1
Received on Fri Jun 04 1999 - 17:34:51 CDT