Re: Very Confused with SQLLoader&^%@?

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 Sun May 23 1999 - 13:03:19 CDT