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

["Harry R Harris" <HHARRIS@alegent.org>]

Thanks Peter, that works even better.

>>> Peter_Burton@Hyperion.com 04/13/04 03:22PM >>>
Harry,

You are most likely running into the 512 character limit imposed by the
CALL
command.

You can try using the LET SYSTEM() function:

    Let #Status = System($mail_cmd)

Peter

> -----Original Message-----
> From:   
sqr-users-bounces+peter_burton=hyperion.com@sqrug.org@HYPERION  On
> Behalf Of "Harry R Harris" <HHARRIS@alegent.org>
> Sent:    Tuesday, April 13, 2004 12:15 PM
> To:    SQR-users@sqrug.org 
> Subject:    [sqr-users] Sending E-mail from SQR
> 
> 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 
> 


************************************************************************

If you have received this e-mail in error, please delete it and notify
the sender as soon as possible. The contents of this e-mail may be
confidential and the unauthorized use, copying, or dissemination of it
and any attachments to it, is prohibited. 

Internet communications are not secure and Hyperion does not,
therefore, accept legal responsibility for the contents of this message
nor for any damage caused by viruses.  The views expressed here do not
necessarily represent those of Hyperion.

For more information about Hyperion, please visit our Web site at
www.hyperion.com

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