![]() |
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| display HTML text in body using unix mailX ???? | sparan_peddu | UNIX for Advanced & Expert Users | 8 | 07-29-2008 10:23 PM |
| Can any body tell me. | sackNumchai | Linux | 3 | 05-05-2008 09:28 PM |
| Mailx : can we have the body to be a binary file ? | CKIRCH | UNIX for Dummies Questions & Answers | 5 | 01-01-2008 03:33 PM |
| mailx: concatenating strings for message body (KSH) | rockysfr | Shell Programming and Scripting | 1 | 07-29-2007 05:12 AM |
| mailx error message : mailx: NUL changed to @ | BG_JrAdmin | UNIX for Dummies Questions & Answers | 2 | 12-01-2005 06:27 AM |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
|
|||
|
MAILX Body containing SQL results
I have a KSH script that runs a SQL script, then sends an email to me indicating that it's completed. I would like to modify it so that the body of the email will contain a count of the number of records Added, Changed, Deleted as a result of the SQL script.
Here's what I was trying, but it's not working...what am I doing wrong? Code:
MESG_GOOD="Completed Successfully" cntADD=sqlplus -s user/pwd select count(*) from tbl where...; cntCHA=sqlplus -s user/pwd select count(*) from tbl where...; cntDEL=sqlplus -s user/pwd select count(*) from tbl where...; content="Adds: " && cntADD && "Changes: " && cntCHA && "Deletes: " &&cntDEL /usr/bin/echo $content | /usr/bin/mailx -s $MESG_GOOD me@here.com Last edited by dstinsman; 10-05-2006 at 12:50 PM. |
| Forum Sponsor | ||
|
|
|
|||
|
Quote:
try this Code:
sqlplus -s user/pwd <<EOF spool /res.lst select count(*) from tbl where..; select count(*) from tbl where..; spool off EOF Code:
sed -n "/--*/{n;p;}" res.lst | tr '\n' ' '| read cntADD cntCHA cntDEL
|
|
|||
|
I don't know about the SQL commands themselves however if you want to assign the output of a command to a variable, you need to use the backtick marks.
Code:
cntADD=`sqlplus -s user/pwd select count(*) from tbl where...;` cntCHA=`sqlplus -s user/pwd select count(*) from tbl where...;` cntDEL=`sqlplus -s user/pwd select count(*) from tbl where...;` Code:
cntADD=$(sqlplus...) cntCHA=$(sqlplus...) cntDEL=$(sqlplus...) Carl |
|||
| Google The UNIX and Linux Forums |