Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Very Confused with SQLLoader&^%@?
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:
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 Fri May 21 1999 - 16:24:51 CDT
![]() |
![]() |