Dear All,
I'm using HP-UX and we have mailx as the mail client.
I want to send a mail from the OS once I get the count from a table on Oracle. I'm thinking of redirecting the count to a file in Unix and get the output. This output spoolfile has to be sent through mail for reference.
Please let me know how can I attach this spoolfile("Status`date '+%d%m%y%H%M'`.txt") to the mail.

Here is the code sample I'm using:

#!/bin/ksh

#. ./set_mail_details.ksh
ORACLE_HOME="/software/ora/oracle/product/8.1.7/"
export ORACLE_HOME
lp=0
count=`/software/ora/oracle/product/8.1.7/bin/sqlplus -s scott/tiger@ora <<EOP
set term off
set heading off feedback off verify off
SELECT count(1) FROM <Table> ;
exit;
/
EOP`

echo "$count" >> "Status`date '+%d%m%y%H%M'`.txt"
echo 'In script'
subject="Status Mail"
echo '\nsubject'
echo "$subject" | sed 's/~/ /g' | read sub
body_of_email=`cat ./Mail.txt`
echo '\nBody\n\n'
echo '\nMail List'
to_list=<recipient@domain.com>
echo "$to_list"
echo "$body_of_email" | sed 's/~/ /g' | read body
(echo "$body";echo "The Count is:\t";echo "$count";echo "\n"; cat MailFooter.txt )| mailx -s "$sub" -r <sender@domain.com> "$to_list"

if [ $? -eq 0 ]
then
echo "Mail is Sent"
else
echo "Mail is not sent(In script)"
fi

Sending a file as attachment through mailx command

hi,
I have even used similar version of the command, but that is also not working....

Please help me.

Regards
RK Veluvali

I have worked with uuencode in HP-UX. Give a try by executing the uuencode by issuing the full path.

If not then try to check out from similar threads like Mail with attachment

Hi,
I'm just debugging some UNIX code which is to be used to send multiple attachments in a single mail.I'm using:

(uuencode $FILE $FILENAME; uuencode $FILE1 $FILENAME1) | mailx -s "$SUBJECT" somebody@some.com

The problem is that, I'm receiving the e-mail with the first file attachment all OK, but the 2nd file as something like :
begin 644 myfile.zip
M4$L#!`H``````*I.)1\]0KO)J5(6`*E2%@`,````1%)5241$,# 0N6DE04$L#
M!`H``````)9C#Q_E,1QY)3D6`"4Y%@`,````1%)5241$14TN03` S8.HL`!X&
M`0`4``*1D6,5'Y%C%1\``````````````````$1254E$1$5-+D$P,P` `<`V[

So, probably, it's printing the encoded file in the mail body for the second attachment.
Can you please help me out with this problem.
A lot of thanks.

Subh