@echo off
for %%g in (C:\test\*.csv) Do (
echo Load Data> kf_nonair.ctl
echo INFILE '%%g'>> kf_nonair.ctl
echo append into table sample_table  >> kf_nonair.ctl
echo FIELDS TERMINATED BY ","   		>> kf_nonair.ctl
echo OPTIONALLY ENCLOSED BY '"'                 >> kf_nonair.ctl
echo ( membership_num              		>> kf_nonair.ctl
echo  , last_name   				>> kf_nonair.ctl
echo  , first_name       			>> kf_nonair.ctl
echo  , award_date				>> kf_nonair.ctl
echo  , miles_awarded "REPLACE(REPLACE(:miles_awarded,',',''),'.','')"	>> kf_nonair.ctl
echo  , award_desc				>> kf_nonair.ctl
echo  , ref_code   				>> kf_nonair.ctl
echo  , part_code				>> kf_nonair.ctl
echo  , trans_date SYSDATE			>> kf_nonair.ctl
echo  , file_name CONSTANT '%%~nxg'		>> kf_nonair.ctl
echo  ^)                                        >> kf_nonair.ctl
call kfnonair.bat
)

Load Data
INFILE 'C:\test\Sample Data.csv'
append into table sample_table  
FIELDS TERMINATED BY ","   				
( membership_num              				
 , last_name   							
 , first_name       						
 , award_date								
 , miles_awarded "REPLACE(REPLACE(:miles_awarded,',',''),'.','')"	
 , award_desc								
 , ref_code   								
 , part_code								
 , trans_date SYSDATE						
 , file_name CONSTANT 'Sample Data.csv'				
 )                                        

11111,LAST_NAME,NAME,07.05.2012,"4,000",KF,PPP,CCCCC,