#!/bin/sh
###################################################################
#export PATH=/opt/IBM/WebSphere/AppServer/java/bin:/home/cognos/cognos/c10/bin64:/home/cognos/oracle:/usr/lib/jdk/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/home/cognos/cognos/transformer/bin
#cd /home/cognos/cognos/transformer/bin
cd /home/cognos/cognos/transformer/bin
baseDirForScriptSelf=$(cd "$(dirname "$0")"; pwd)
echo "full path to currently executed script is : ${baseDirForScriptSelf}"
###################################################################
year_month="`date +%Y%m`"
month_first_day=`date +%Y%m01`
last_day=$(echo `cal|awk '{if(NR!=1 && NR!=2)print $0}'|awk 'BEGIN{sum=0}{split($0,array," ");for( i in array) if(array[i]!="") print array[i]}'|wc -l`)
#echo $last_day
month_last_day=$year_month$last_day
#echo $month_first_day-$month_last_day
filename="/home/cognos/cube/a/"$month_first_day"-"$month_last_day.mdc
#echo $filename
if [ -f $filename ]
then
rm -r $filename
./cogtr -c -p/home/cognos/cube/a.pyj>/home/cognos/cube/a.log