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

[Peter Burton <Peter_Burton@Hyperion.com>]

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
Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users