Shulou(Shulou.com)06/01 Report--

File name: addtrandata.sh

Path: $HOME/ggscript/gginsert

Function: it is used to add table additional logs in batches, which is an independent function from the add table script, and is used to deal with the loss of table additional logs and the failure of adding table additional logs.

#! / bin/bashecho "This script will add trandata (by RenYi)" ls-lrt $HOME/ggserver/dirprm/e*.prmecho "The EXTRACT process:" cd $HOME/ggserver (echo info all;echo exit) |. / ggsci | grep "EXTRACT" | awk 'BEGIN {FS= "+"} {print $3}' | grep'^ E'cd $HOME/ggscript/gginsertecho "Please press any key" read-n 1read-p "Please enter the EXTRACT name:" val2val= `echo $val2.PRM | tr Amurz-z`cd $HOME/ggserver/dirprmif [!-e $val] Then echo "the EXTRACT is not exist" echo "the EXTRACT is not exist" > >'$HOME'/gglog/gginsert/InsertLog-'$backuptime'.log' exit 2fiecho "Please Enter the table (Please enter any key)" read-n 1cat / dev/null > trandaTmpvi trandaTmpsed's / ^ / addtrandata / 'trandaTmp > addtrandataNUX= `sed-n' $= 'addtrandata`echo $NUXi=1echo $icd $HOME/ggserverecho dblogin `more $HOME/ggserver/dirprm/$val | grep USE RID` > dirdat/addtrandataecho $login While ["$I"-le "$NUX"] do sed-n "${I} p" $HOME/ggscript/gginsert/addtrandata > > dirdat/addtrandata I = `expr $I + 1`doneecho OBEY dirdat/addtrandata |. / ggsci

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.