Re: [sqr-users] Sending E-mail from SQR

["Jamie Harris" <JHarris@frederick.edu>]

I think the problem is that on any system there is X number of
characters allowed in a command-line.  If you go over that limit,
unpredictable results will occur.  In your case the end of the command
line is getting chopped-off (the address - arguably the most important
part of the command you're executing).   

You may want to try creating a file in SQR that is a text-file which
contains the body.  Depending on what you are doing you'll of course
need to watch out for concurrency issues (ie. use unique file names
somehow - include the date, time and/or process ID in the file name) and
security issues also if the body contains any information you don't want
people to see.  

Once the body is created, do this:

let $mail_cmd = 'cat ' || $body_file || '|' || ' mailx -s ' || $subject
||
$address


Then when you're done you could clean-up the body file like this:

let $del_cmd = 'rm ' || $body_file 


Hope this helps! :)

-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> HHARRIS@alegent.org 4/13/2004 12:14:54 PM >>>
I am trying to send an email from within an SQR using the following:

let $mail_cmd = 'echo' || $body || '|' || ' mailx -s ' || $subject ||
$address

call system using $mail_cmd #status nowait

Seems to work fine until $body contains more than about 500
characters.???

We are: SQR for PeopleSoft/8.19/IBM RS6000/AIX 5.1/Oracle 9.2.0.4


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users