#!/bin/csh
if($#argv!=1 then
echo"Usage:cshdeltmp.sh[dbname]";
exit(0);
elseif($#argv==1 then
setdbname="$argv[1]";
endif
rmdeltmp*.sql
echo"nowloadtmptabletodeltmp.sql"
dbaccess$dbname<<EOF
unloadto"deltmp.sql"
selecttabnamefromsystableswheretabnamelike"tmp%"andcreated<extend(current,yeartoday)
EOF
echo"loadfinish"
echo"|-->;"
sed's/|/;/wdeltmp1.sql'deltmp.sql
echo"tmp-->droptabletmp"
sed's/tmp/droptabletmp/wdeltmp2.sql'deltmp1.sql
echo"deletetemptable"
dbaccess$dbnamedeltmp2.sql
echo"deleletempfiles"
rmdeltmp*.sql
时间: 2024-08-30 21:06:34