Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Very Confused with SQLLoader&^%@?

Very Confused with SQLLoader&^%@?

From: Michael Sessions <msessions_at_aldensys.com>
Date: Fri, 21 May 1999 16:24:51 -0500
Message-ID: <p6k13.3028$K25.698@news4.mia>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US