LOAD DATA 
INFILE *
BADFILE 'LSN.bad'
DISCARDFILE 'LSN.dis'
APPEND

INTO TABLE MPWSADMST.L_SN
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'	
(ID,MATERIAL,revision,MATERIAL_TYPE,STATUS,MID,GRN,GRN_TS "to_date (replace (replace (:grn_ts, '/', ''), ' ', ''), 'mmddyyyy')",GRN_UID,PON,PON_TS "to_date (replace (replace (:pon_ts, '/', ''), ' ', ''), 'mmddyyyy')",PON_UID,DNN,DNN_ITEM,DNN_TS "to_date (replace (replace (:dnn_ts, '/', ''), ' ', ''), 'mmddyyyy')",DNN_UID,WEIGHT,PEDIMENTO,PEDIMENTO_TS "to_date (replace (replace (:pedimento_ts, '/', ''), ' ', ''), 'mmddyyyy')",DATA_1,DATA_2,DATA_3,TS_1 "to_date (replace (replace (:ts_1, '/', ''), ' ', ''), 'mmddyyyy')",TS_2 "to_date (replace (replace (:ts_2, '/', ''), ' ', ''), 'mmddyyyy')",PID,CMID,CPID,XID)		

BEGINDATA
"350005600936939","0505003",0,3,20,"GG002811","mpwstompws_17122",12/12/2004,"TEPTOIVO","DG0016",04/11/2000,NULL,NULL,NULL,//,NULL,0,NULL,//,NULL,NULL,NULL,04/11/2000,//,NULL,NULL,NULL,NULL