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

Home -> Community -> Mailing Lists -> Oracle-L -> Sqlloader

Sqlloader

From: <Roland.Skoldblom_at_ica.se>
Date: Tue, 13 Nov 2001 11:53:38 -0800
Message-ID: <F001.003C3BB2.20011113111706@fatcity.com>

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

=?iso-8859-1?Q?arg.log?=
Description: Binary data


Received on Tue Nov 13 2001 - 13:53:38 CST

Original text of this message

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