UNIX for Dummies Questions & Answers

filename=testdata921 export filename
UTLFILE_DIR=/tmp1/test export UTLFILE_DIR
mailids=`
sqlplus -s $Username/$Pwd@$Database <<EOF
set heading off
set feedback off
select email_address from email_list where APPLICATION='TESTDATA921';
exit
EOF`
echo "$mailids"
sqlplus << EOF
$Username/$Pwd@$Database
whenever sqlerror exit failure;
execute PRC_FILE_GENERATE; --this generates testdata921 file
EOF
RC=$?
if [ $RC = 0 ]
then
echo "SQL executed successfully...."
cd $UTLFILE_DIR
unix2dos $filename.csv $filename.tmp
(uuencode $filename.tmp $filename.csv) | mailx -s "TESTDATA921 File" $mailids
 
else
echo "SQL was NOT successfully executed...."
echo "Program exited with RC=$RC"
exit $RC
fi

select email_address from email_list where APPLICATION='TESTDATA921'; 
 
Sasikala.Mohan@xyz.com, Elaiyapallavan.Murugan@xyz.com, Nagamarimuthu.Karuppiah@xyz.com

bash-3.00$ int1247_syst_1.ksh
Sasikala.Mohan@xyz.com,Elaiyapallavan.Murugan@xyz.com,Nagamarimuthu.Karupp
iah@xyz.com

Sasikala.Mohan@xyz.com
Elaiyapallavan.Murugan@xyz.com
Nagamarimuthu.Karupp@amrndhp0001g.xyz.com
iah@xyz.com

(uuencode $filename.tmp $filename.csv) | mailx -s "TESTDATA921 File" Sasikala.Mohan@xyz.com,Elaiyapallavan.Murugan@xyz.com,Nagamarimuthu.Karuppiah.xyz.com

mailids='Sasikala.Mohan@xyz.com,Elaiyapallavan.Murugan@xyz.com,Nagamarimuthu.Karuppiah@xyz.com';

(uuencode $filename.tmp $filename.csv) | mailx -s "TESTDATA921 File" `echo "$mailids"`

echo "select email_address from grw_email_list where APPLICATION='BEVDATA921';
exit
" | sqlplus -s $Username_ODS/$Pwd_ODS@$Database_syst | \
while read line
do
if [[ $i -gt 2 ]]
then
arr[$i-3]="$line"
fi
i=$i+1
done
i=0
b=" "
while [ $i -lt ${#arr[@]}-1 ]
do
if [ $i -eq ${#arr[@]}-2 ]
then
a=$a${arr[$i]}
else
a=$a${arr[$i]}$b
fi
(( i=i+1 ))
done
email_suc=$a
infile=`echo "$email_suc" | sed 's/ //g'`