Re: Sqlloader

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 13 Nov 2001 12:26:12 -0800
Message-ID: <F001.003C3CFA.20011113120709@fatcity.com>

Roland,

Your log file tells you exactly, what to do: use 'TRAILING NULLCOLS' in your ctl-file (when the last column value is NULL).

BTW, why don't you ever RTFM???

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 13, 2001 2:17 PM

Hallo,

I am running this sqlloader ctl-file

load data
infile 'C:\temp\arg\argdwfkt3.txt'
TRUNCATE
into table argdwfkt_kopia
FIELDS TERMINATED BY ';'
(BUTIKS_ID,

BUT_NAMN,
REGION_ID "DECODE(:REGION_ID,'!','98','?','97',:REGION_ID)", DISTRIKT_ID "DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID)", ROLL_ID,
PROFIL_ID "DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID)", AR,
KVARTAL,
MANAD,
VECKA,
DOKUMENTTEST_ARKFORMAT
"DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97' ,'99')",
KAMPANJ_TYP,
MX_URVAL,
POSTBEFODRAN
"DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99')", PRINT_FORETAG_ID
"DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99')", STYCKKOSTNAD,
FASTKOSTNAD_BREVMALL,
FASTKOSTNAD_ARENDE,

 TOTAL_KOSTNAD,
 ANTAL_ÄRENDEN,
 ANTAL_BREVMALLAR_I_ARENDE,
 ANTAL_KUNDSEGMENT_I__ARENDE,
 ANTAL_KUNDER_I_URVAL,
 DATUM_HOS_KUND,

AKTIVITETS_LOPNR,
PRODUKTIONSENHET,
AKTIVITETSDATUM,
BEHANDLINGSGRP) but gets this error message, check the file:What does it mean and how should I fix this:

(See attached file: arg.log)

Thanks in advance

Roland S

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Nov 13 2001 - 14:26:12 CST