Hi Tamil,
I have 300 columns.
Please find the attached ctl file.
LOAD DATA
INFILE "/var/opt/ascential/data/jj/CDRNOK_MSCHEMCHU1_20051106010701_2547.dat.bman.1219332"
APPEND
INTO TABLE CDR_TMPJJ
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(...
)
Thanks




Reply With Quote