hello all,

i have a text file which is like this

74,001,AFGHANI,, - -,
74,002,TURKEY,, - -,
74,003,CHINA OAK,, - -,
74,004,IRAN,, - -,
74,005,AMIRAN OAK,, - -,
74,006,PAKISTAN HK,, - -,

the table :-

icmasqua (company varchar2(2) primary key, masqua varchar2(3) NOT NULL,
name varchar2(30) NOT NULL,
family varchar2(2) NOT NULL,
lastupd date NOT NULL,
upduser varchar2(15) NOT NULL)

how can i write a control file to load data into the not null columns if there is no data for the respective fields in the text file ??


i know this control file wont work

LOAD DATA
INFILE 'c:\icmasqua.txt'
INTO TABLE icmasqua
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(company,masqua,name,family,lastupd,upduser)


thanks