Inserting subject for the mails sent through SQR


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Inserting subject for the mails sent through SQR
# 1  
Old 03-30-2012
Inserting subject for the mails sent through SQR

I am trying to insert subject for the mails sent through one of our sqr process using below code

Code:
Let $Email_Command = 'uuencode ' || $filename || ' ' || $filename || ' | sendmail -F''' ||$subject || ''' ' ||$mailid1 || ''' ' ||$mailid2
 CALL SYSTEM USING $Email_Command #return_code WAIT

Through variable $filename, I am sending an attachment in the mail.

Values which we are giving for the variable $subject is displayed in mail has from.


Please help us in correcting the above code .To display subject, from and to


Moderator's Comments:
Mod Comment Please use next time code tags for your code and data

Last edited by vbe; 03-30-2012 at 09:03 AM..
# 2  
Old 04-02-2012
Please send us sample code for CODE TAGS.

we are assigning the unix code to variable , using peoplesoft function we are calling unix code to send email from our SQR process.

Code:
Let $Email_Command = 'uuencode ' || $filename || ' ' || $filename || ' | sendmail -F''' ||$subject || ''' ' ||$mailid1 || ''' ' ||$mailid2

 CALL SYSTEM USING $Email_Command #return_code WAIT

above code is only giving the from and attachment , but its not allowing us to insert the subject and to details in mail.

Please send us sample code for CODE TAGS.

Last edited by Scrutinizer; 04-02-2012 at 09:19 AM.. Reason: code tags and formatting
# 3  
Old 04-02-2012
Quote:
Originally Posted by thangaga
Please send us sample code for CODE TAGS.
Just click on the link in the moderator comments in post #1
# 4  
Old 04-02-2012
What unix Operating System and version you have?
Afaik there is no command line option for "subject" in "sendmail". The "-F" parameter sets the full name of the sender.
Do you have an example which works directly from the unix command line?

You may find it much easier to use mailx (or mail if this is a version of Linux with no mailx).
# 5  
Old 04-03-2012
Inserting subject for the mails sent through SQR

we are not sure of the UNIX version which we are using.

we have already tried mailx.


Code:
 let $exec_email = 'mailx -s "' || $subject || '" ' || ' -r' || -
                           ! ' "' || $reply_email || '"' || ' "' || $to_email || -
                           ! '"' || ' < ' || $filename



call system using $exec_email #ret_cd wait

using this code we not able to send the attachments . Please help in modifying the above code.

Last edited by Scrutinizer; 04-03-2012 at 03:29 PM.. Reason: code tags
# 6  
Old 04-03-2012
The syntax for mailx with a attachment should be pretty much the same as your sendmail line in post #1 but with "sendmail -F" replaced with "mailx -s".
Unfortunately there is much variation in "mailx" command, so try from the command line first and check your local man mailx .


Your unix type and version can be displayed with:
Code:
uname -a

Post with anything confidential blocked (like machine names).
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Running an SQR from shell script

Hi, I am trying to run an SQR from unix shell script. but the SQr errored out with the following message SQR (1201) Cannot open argument file (2) No such file. Can anybody help me ragrding this. I m using this to run the SQR. $2 is the sqr name and $3 is the parameter file name. sqrun... (1 Reply)
Discussion started by: Aswathy88
1 Replies

2. Shell Programming and Scripting

How to write a script in unix to get value from SQR?

hi this is naga, i had created one SQR , but i didnt include the code to get the notification(failure or success ) thats way every time its returning the status=0 SQR was went to success(if it failed also), without touching the code of the SQR can any one help to write script in unix to get... (4 Replies)
Discussion started by: nagavenkatesh
4 Replies

3. SuSE

mails not getting sent ...

Guys I have not much idea on suse or any other linux flavour. This is what i have: cat /etc/issue Welcome to SUSE LINUX Enterprise Server 9 (i586) - Kernel \r (\l). ps -ef |grep postfix |grep -v grep root 18620 1 0 Mar17 ? 00:00:00 /usr/lib/postfix/master postfix ... (0 Replies)
Discussion started by: ak835
0 Replies

4. Shell Programming and Scripting

connecting to different database in sqr

Hi, My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies

5. Shell Programming and Scripting

SQR error 5528

Hi, I'm trying to execute a script which calls a SQR. The SQR is throwing an error SQR 5528-sybase ct_connect error in cursor 0 Login falied SQR 4701-Cannot connect to the database I'm not sure where is the id/password specified as this is an existing script. Any idea as where is... (1 Reply)
Discussion started by: autosys_nm
1 Replies

6. Gentoo

inserting grep -c value into an email subject

I am profoundly new to *nix, but had a project dropped in my lap that has sparked an interest, leading me here. I was tasked with daily sending one of our customers a listing of all the spam our filter blocked that was heading for them. Between Google and I; I discovered the Server is running... (3 Replies)
Discussion started by: GrendelPrime
3 Replies

7. UNIX for Advanced & Expert Users

Passing values from SQR to UNIX

UNIX script running a SQR program.... no problem passing values to SQR program... trying to pass values back to UNIX.... I'm currently creating a file from the SQR program and then using the Unix READ command to read the file and retrieve the value.... Is there an easier way to pass the... (2 Replies)
Discussion started by: seeuinoz
2 Replies

8. UNIX for Dummies Questions & Answers

SQR to UNIX

UNIX script running a SQR program.... passing values to SQR program... trying to pass values back to UNIX.... I'm currently creating a file from the SQR program and then using the Unix READ command to read the file and retrieve the value.... Is there an easier way to pass the values back from... (0 Replies)
Discussion started by: seeuinoz
0 Replies

9. Shell Programming and Scripting

What is sqr ?

Hi , I came along a command sqr in shellcscript. It was sqr process_name parameters. Could you please tell me what does it mean. Regards Ashish Malviya :) (1 Reply)
Discussion started by: Ashishm
1 Replies

10. UNIX for Dummies Questions & Answers

Changing persmissions for output file in UNIX box with SQR.

I am trying to change permissions on an output file from an sqr. The file is pushed out into a directory on the unix box. I am using the following code in the sqr to accomplish this. if $OUTPUT <> '' let $unix_call = 'chmod 664 '||$OUTPUT show $unix_call CALL SYSTEM Using... (1 Reply)
Discussion started by: evengetsteven
1 Replies
Login or Register to Ask a Question