Re: Very Confused with SQLLoader&^%_at_?

Disregard. The problem is most probably that you need a line feed after your last line in the .ctl file. I've had the same error in that situation.

Danielle Engel wrote:

> Try putting a right parenthesis at the end of your .CTL file!!
>
> Michael Sessions wrote:
>
> > After running this command from MS-DOS prompt:
> >
> > SQLLDR80 USERID=AIT/ADMIN CONTROL=AITHW.CTL
> >
> > I get:
> >
> > SQL*Loader-524: partial record found at end of datafile (aithw.ctl).
> >
> > AITHW.CTL:
> >
> > -- SQL*Loader Control Script: Hardwire Inventory
> >
> > -- MODIFIED (MM/DD/YY) COMMENTS
> > -- mgsessions 05/21/99 Initial Creation
> >
> > OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)
> > UNRECOVERABLE
> > LOAD DATA
> > INFILE 'Aldenhwsub.dat' "FIX 133"
> > TRUNCATE
> > INTO TABLE AITHW
> >
> > (STATE POSITION (01:02) CHAR,
> > AREA POSITION (03:09) CHAR,
> > IMPORT_DAT SYSDATE,
> > CPR POSITION (16:21) CHAR,
> > FRC POSITION (25:29) CHAR,
> > FLOOR POSITION (30:31) CHAR,
> > FRAME_ID POSITION (32:40) CHAR,
> > YR POSITION (41:42) CHAR,
> > QTY POSITION (43:50) INTEGER EXTERNAL,
> > MAT_COST POSITION (51:62) DECIMAL EXTERNAL,
> > INPL_COST POSITION (63:74) DECIMAL EXTERNAL,
> > ECN POSITION (75:79) CHAR,
> > ECN_INPL POSITION (80:91) DECIMAL EXTERNAL,
> > BASIC POSITION (94:105) CHAR,
> > PART POSITION (106:132) CHAR)
> >
> > AITHW.dat(Fixed-Field):
> >
> > ILQ65470 020199 100377C 01 IOE-N00196 1 589.10 0.00
> > 0.00HW
> > MIM54150 020199 100257C 04 DKMTD 95 1 9040.00 0.00
> > 0.00HW
> > WIPW0114 020199 100377C 01 DLU001092 1 289.90
> > 272.67607F0 272.67HW
> > MIM11789 02019909999 100257C 01 010101 96 1 146.59 0.00
> > 0.00HW
> > ILQ11590 020199A50001100357C 01 10100 93 1 1143.00
> > 3856.11813 3856.11HWSHELF SHELF
> > ILQ11590 020199A50001100357C 01 10102 93 3 3429.00
> > 11000.52813 11000.52HWSHELF SHELF
> > ILQ12220 020199A50001100357C 03 30230 91 1 4795.00
> > 6687.50814 6687.50HWSHELF SHELF
> > ILQ12860 020199A50001100357C 02 20604 92 0 4724.58
> > 7373.10814 7373.10HWSHELF SHELF
> > ILQ13830 020199A50001100357C 03 33614 91 1 4795.00
> > 21948.11814 21948.11HWSHELF SHELF
> > ILQ24920 020199A50001100357C 01 15702 92 1 665.10
> > 2611.47813 2611.47HWSHELF SHELF
> >
> > Running on Windows NT server.
> >
> > My Oracle8 AITHW table is not receiving these records. What am I doing
> > wrong?
> >
> > Regards,
> >
> > MGS
Received on Mon May 24 1999 - 04:53:41 CEST