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

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

Reply via email to