FILE_NAME=`basename $0 .ksh`

SPOOL_FILE=${INBOUND}/$FILE_NAME.spool
LOG_FILE=${INBOUND}/$FILE_NAME.log

#| check for correct number of parameters

if [ $# -ne 4 ]
then
   echo " "
   echo " Incorrect number of parameters entered..."
   echo " Correct usage: " $0 "<TGT USERID> <TGT PASSWD> <TGT DSN> <TABLE NAME>"
   echo " "
   exit 1
fi
#------------------------------------------------------
#       Initialize variables
#------------------------------------------------------
TGT_USERID=$1
TGT_PASSWD=$2
TGT_DSN=$3
TABLE_NAME=$4

DT_START=`date`

echo "-----------------------------------------" >> $LOG_FILE
echo "Execution Started at :"$DT_START>>$LOG_FILE
echo "Connecting to Oracle...">>$LOG_FILE

tab=`$ORACLE_HOME/bin/sqlplus -s /nolog <<EOF >>$LOG_FILE
      CONNECT ${TGT_USERID}/${TGT_PASSWD}@${TGT_DSN}
      set lines 250
      set trims off
      set wrap off
      set head off
      set pages 0
      spool $SPOOL_FILE

      WHENEVER SQLERROR EXIT SQL.SQLCODE;

      TRUNCATE TABLE ${TABLE_NAME};

      spool off;
      exit
EOF`

SQL_STATUS=$?

if [ ${SQL_STATUS} -ne 0 ]
then
   echo "Error in the SQL...."  >>${LOG_FILE}
else
   echo "Successfully truncated ${TABLE_NAME} table..."  >>${LOG_FILE}
fi

DT_END=`date`

echo "Execution Ended at :"$DT_END>>$LOG_FILE
echo "--------------------------------------------">>$LOG_FILE
exit ${SQL_STATUS}