[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] How to email lis/pdf output file from SQR executed in PeopleSoft on UNIX
- Subject: RE: [sqr-users] How to email lis/pdf output file from SQR executed in PeopleSoft on UNIX
- From: Bob Stone <bstone@fastenal.com>
- Date: Thu, 23 Jun 2005 13:09:39 -0500
- Delivery-date: Thu, 23 Jun 2005 13:10:49 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
uh...create the file first and then email?
I've created a file and sent it, but instead of using the print commands I
would use open/write/close commands for the file. Then I could close it off
and email it before the end of the program.
Otherwise, you could create another SQR that runs right after it that just
emails the outputted file after successful completion of the first...make
some sort of PS job that puts the 2 together.
-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Wood, Jason
Sent: Thursday, June 23, 2005 12:44 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to email lis/pdf output file from SQR executed
in PeopleSoft on UNIX
Is there a way to email the output file from an SQR executed in
PeopleSoft? I've used the "call system" command and "mailx -s" command
to successfully email an existing file on UNIX, but I can't email the
output file of the SQR program since it does not exist at the time I
execute the mailx -s command. Any ideas?
Thanks, Jason
Jason C. Wood
PeopleSoft Sr. Systems Analyst
RGA Reinsurance Group of America
Phone: (636) 736-8104
Fax: (636) 736-8504
jwood@rgare.com
_______________________________________________
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