#! /bin/ksh
sid=$1
sid1=${1}1
sid2=${1}2
export RPTDATE=`date '+%m%d'`
export SCRPTDIR=$PWD
export RPTDIR=$PWD

export OUTFILE=$RPTDIR/COMP_DistinctUsersOrdered_Report.csv

PATH=$ORACLE_HOME/bin:/bin:/usr/local/bin:${PATH}

export PATH

>$OUTFILE


sqlplus 'sgovind/gagh3wium@//64.106.198.179:1571/COMPROD1' @$SCRPTDIR/COMP_DistinctUsersOrdered_Report.sql

sed -e 's/[\t ]//g;/^$/d' $RPTDIR/COMP_DistinctUsersOrdered_Report.csv>DistinctUsersOrdered_Report.csv

cd /home/wipro/EmptyReport
touch DistinctUsersOrdered_Report.csv
chmod 777 *

export ATTFILE=$RPTDIR/DistinctUsersOrdered_Report.csv

/usr/bin/mutt -a $RPTDIR/DistinctUsersOrdered_Report.csv -s "$1Distinct Users Ordered Report `date` " vbho687@its.jnj.com,sgovind1@its.jnj.com < $RPTDIR/mailMessageDistinctUsersOrdered.txt

exit