ftp下载 入库 调存储过程处理 备份文件

 

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