My docs don't have this error: SQL*Loader-524

From: Richard Billingsley <rbillingsley_at_deadend.com>
Date: Mon, 13 Mar 2000 20:19:26 GMT
Message-ID: <i3cz4.375$511.98494@tw11.nn.bcandid.com>

While attempting to create and run a SQL*Loader control file I got the following error:

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

My error docs stop at 523, then jump to 600.

Does anyone know what this error means and how to fix it.

I've counted my load records and they match the size defined.

load data
infile 'st_phone_data.txt'
badfile 'st_phone_data.bad'
into table storm_job_history
( empno position(001:009) char,

 beeper                          position(010:034) char,
 dig_alpha                      position(035)  char,
 da_desc                       position(036:050) char,
 work_number                position(051:085) char,
 alt_work_number           position(086:109) char,
 mobile_number              position(110:145) char,
 available_storm             position(146)  char,
 primary_job_code          position(147:149) char,
 primary_jog_desc          position(150:179) char,
 primary_job_loc             position(180:182) char,
 secondary_job_code      position(183:185) char,
 secondary_job_desc      position(186:215) char,
 secondary_job_loc         position(216:218) char,

 primary_effective_date1 position(219:224) date "YYMMDD",  primary_effective_date2 position(225:232) date "YYYYMMDD")

--
Richard Billingsley

Note: To reply via email replace "deadend.com" with "vbig.com" before sending. Received on Mon Mar 13 2000 - 14:19:26 CST