SQLLDR80 -- WHY IS THERE AN ERROR?

From: Joe Sugden <jsugden_at_netmeg.no.spam.net>
Date: Thu, 21 Oct 1999 16:16:30 GMT
Message-ID: <y%GP3.2189$hK6.120904_at_monger.newsread.com>

I have been getting the following error while trying to load the attached control file. I can't figure out why and the documentation does not contain any advise.

"SQL*Loader-524: partial record found at end of datafile (MPDB1.CTL)"

This is how I have been entering the following at the command line (password, login and host excluded) while in the directory containing the CTL file (I'm on a win95 client w/ a NT server).

"SQLLDR80 LOGIN/PASSWORD_at_HOST CONTROL=MPDB1.CTL LOG=MPDB1.LOG"

This is, as far as I can see, the same procedure that I have followed every other time that I have loaded data--Long directory names, drive locations, format of ctl files. What is going on? Thanks for the help.

The control file MPDB1.CTL is as follows:

LOAD DATA
INFILE 'C:\data\1403A - FSC Application

Development\Promotion\MPDB\MPDB1.1.TXT'
BADFILE 'C:\data\1403A - FSC Application
Development\Promotion\MPDB\MPDB1.1.TXT'

INFILE 'C:\data\1403A - FSC Application

Development\Promotion\MPDB\MPDB1.2.TXT'
BADFILE 'C:\data\1403A - FSC Application
Development\Promotion\MPDB\MPDB1.2.TXT'

INFILE 'C:\data\1403A - FSC Application

Development\Promotion\MPDB\MPDB1.3.TXT'
BADFILE 'C:\data\1403A - FSC Application
Development\Promotion\MPDB\MPDB1.3.TXT'

APPEND INTO TABLE SCRUB.J_MPDB
FIELDS TERMINATED BY ';' (YEAR_WEEK
, AREA_ID
, PRICE_ZONE
, CATEGORY
, SALES_PROGRAM
, SHOP_ID
, BUYER_NUM
, MOD_TYPE
, ORDER_TYPE
, ITEM_NUM
, ITEM_DESC
, NUM_WKS
, REG_RETAIL_UNIT
, REG_RETAIL
, SALE_UNIT
, SALE_RETAIL)
Received on Thu Oct 21 1999 - 18:16:30 CEST