HI All,
Newbie here.
I have a script which generates the tables in teradata database with time stamp like below.I want to add some more code to delete the archive tables which are 2months old.
. $HOME/.profile
t_name=$1
procdate=`date +%y%m%d`
log_dir=$Folder/log
tab=`echo $t_name""$procdate`
tab_create=$log_dir/$t_name.txt
param_dir=$Folder/parameter
echo ".run file=$param_dir/logon.txt;" > $tab_create
echo "DATABASE XYZ;" >> $tab_create
echo ".echoreq off;" >>$tab_create
echo ".SET FOLDLINE off; " >>$tab_create
echo "rename table $t_name to $tab;" >> $tab_create
echo ".if errorcode =3803 then .goto prob38;" >> $tab_create
echo "create table $t_name as $tab with no data;" >> $tab_create
echo ".quit;" >> $tab_create
echo ".LABEL prob38" >> $tab_create
echo "drop table $tab;" >> $tab_create
echo "rename table $t_name to $tab;" >> $tab_create
echo "create table $t_name as $tab with no data;" >> $tab_create
echo ".quit;" >> $tab_create
echo "EOF" >> $tab_create
bteq < $tab_create> $log_dir/$tab_create$tab.log
Can someone help me on this..
Thanks.
Regards,
Mav.