本文共 779 字，大约阅读时间需要 2 分钟。

 

FTPHOST="132.35.77.999"

USERNAME="xxxxxx59" PASSWORD="xxxxxx59" YESTERDAY=`TZ=aaa24 date +%Y%m%d` CURDATETIME=`date +'%Y-%m-%d %H:%M:%S'` FILENAME=KCY59CY*.TXT echo $FILENAME ftp -i -n $FTPHOST<<FTPIT user $USERNAME $PASSWORD cd ./outgoing lcd /product1/interf/bin/HQ2/hq2_bss_materials/card_quali_sampling bin prom mget ${FILENAME} quit FTPIT #执行导入 /product1/interf/bin/HQ2/hq2_bss_materials/card_quali_sampling/imp_kcy echo "" echo "" echo "" echo "*******************************开始处理*********************";

DIR_LIST="/product1/interf/bin/HQ2/hq2_bss_materials/card_quali_sampling"

LOG_LIST="KCY59*.TXT" cd $DIR_LIST for log_part in $LOG_LIST do sqlplus /nolog<<! conn busi/"xxxxxxx"@newbss; exec proc_card_sampling('$log_part'); commit; exit; ! mv  $log_part $DIR_LIST/bak done

转载地址：http://nlvwn.baihongyu.com/