sqlloader 倒数脚本

echo "********************************************"
echo "倒数脚本"
echo "导入表为：hi.tb_test_input"
echo "********************************************"                            
echo "请先清空临时表数据 truncate table hi.tb_test_input; "
echo "临时表清空了吗(Y/N)"
read ans
echo "请输入要上传的文件名称"  
read name              
#"*********把文本中的'M'替换成空格**********"
//'  /jm_temp/BACKUP/$name>/jm_temp/BACKUP/input.txt
echo "替换完成，详情请查看input.txt"   
echo "loAD DATA
INFILE /"/jm_temp/BACKUP/input.txt/"
append into table hi.tb_test_input
 fields terminated by /"/"
 trailing nullcols
                                (
        servnumber                                                                                           
                                )">hdjr_20101206.ctl           
                                               
sqlldr userid=username/password@database control=hdjr_20101206.ctl data=/jm_temp/BACKUP/input.txt log=hdjr_20101206.log errors=0 direct=true

 

 

--------------------------------------------------------------

cat>test.ctl 
loAD DATA
INFILE "/jm_temp/kkk/test.txt"
 truncate into table hi.tb_kkk_20101104_lodr
 fields terminated by "|"
 trailing nullcols
 (                                  
    servnumber     "trim(:servnumber)"   
   ,slrq           "trim(:slrq)"   
   ,famc           "trim(:famc)"                                                                                                                                           
 )   
 
                        
sqlldr userid=username/pwd@database control=test.ctl  data=/jm_temp/kkk/test.txt log=hdjr_20101206.log errors=0 direct=true

 

 

cat>hdjr_20101206.ctl
loAD DATA
INFILE "/jm_temp/BACKUP/t.txt"
append into table hi.tb_test_input
 fields terminated by ""
 trailing nullcols
                 (
     servnumber                                                                                           
                 )