Re: Very Confused with SQLLoader&^%@?

The carriage return should be on the end of your .csv file (or datafile) not at the end of the .ctl file.

Mark

Michael Sessions wrote in message ...
>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 - 03:55:37 CDT