Shell Programming and Scripting

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.

Code:

spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;

Moderator's Comments:

Please use code tags next time for your code and data. Thanks

Hello and Welcome to The UNIX and Linux Forums!

Your Post was moved to shell scripting forum

Please read the our FAQ on how to post new threads in the forums.

As a registered user you can go to any forum where you have permission to post and create new threads, view threads and leave replies. You should always search the forums before posting a new thread (Google Site Search).

To create a new thread, click on a forum you would like to post in, for example, UNIX for Dummies Questions & Answers, and then click on the new thread icon

To reply you have a few options. You can click on the 'Post Reply' button and add a new post to the end of the thread. Alternatively, you can leave a quick reply in a quick editor box listed below the posts in the thread.

If you have further questions on forum operations, do not send email or private messages (PMs) to us. You are required to post these questions here:

Post Here to Contact Site Administrators and Moderators



Enjoy, Learn and Teach!

The UNIX and Linux Forums

Welcome to the forum
To be able to give you an answer, we would need to know the OS and shell you are using, and see your script and the error messages if any, the little SQL code extract you gave is clueless to us

I am using korn shell on an AIX machine..
shell script as below:

Code:

. /ptma/ptma.profile;
echo $DB_PASS | sqlplus $DB_USER@$DB_SID @/ptma/ActivationCountCheck/ActivationCountCheck.sql;
mail -s "Activation Count of Last Day" someone@something.com < table_update.html
exit;

while the sql file has:

Code:

spool table_update.html;
SELECT appid, sum(resp) 
FROM PROCESS_LOG_STATS 
where process = 'ActivateSubscription' and ddate > sysdate-2 group by process, appid ORDER BY process, appid;
spool off;

The mail is triggrred but body of mail has data in text format but not in proper report/excel/html format.

Moderator's Comments:

Please use code tags next time for your code and data. Thanks

Looks like you will have to send your report as an attachment if you want to keep the HTML format...

This is how I used to transfer fancy stuff and binaries: (Because I remember at the time I had issues when sending .doc or .xls files...)

Code:

cp myheader > /tmp/mailtmpfile
uuencode /path/datafile datafile >> /tmp/mailtmpfile
cat /tmp/mailtmpfile | sendmail -t 
rm /tmp/mailttmpfile

Thank you moderator! I am on verge to get this info.. if I succeed, I will paste it here... I think its doable but its not easy.. I googled a lot but could not find it anywhere..

What does this give as output?

Code:

uuencode -m table_update.html table_update.html|  mail -s "Activation Count of Last Day" someone@something.com