Re: [sqr-users] How to email lis/pdf output file from SQR executed inPeopleSoft on UNIX

[Olga.Gal@bbh.com]

Try to do NEW-REPORT dummy-filename  before you execute your CALL SYSTEM.

NEW-REPORT will close the current report, which is your real output, and open a 
new (dummy) report file. Then, I think,  you can do whatever you want with your 
output file.

Also, if your output is generated from an interim SPF file, you may need to 
call SQRP command to convert it to your desired output type. Normally SQR does 
it automatically upon completion.  For example for PDF output you do:

CALL SYSTEM USING  'sqrp myfile.spf  -printer:pd'  #status NOWAIT

Hope it helps.


                                                                                
                                                                                
                                                                                
               
             "Wood, Jason" <JWood@rgare.com>                                    
                                                                                
                                                                                
               
             Sent by: sqr-users-bounces+olga.gal=bbh.com@sqrug.org              
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
            To 
                                                                                
                               <sqr-users@sqrug.org>                            
                                                                                
               
             06/23/2005 01:43 PM                                                
                                                                                
                                                                                
            cc 
                                                                                
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
       Subject 
                                                 Please respond to              
                               [sqr-users] How to email lis/pdf output file 
from SQR executed in  PeopleSoft on UNIX                                        
                   
               "This list is for discussion about the SQR database reporting  
language from Hyperion                                                          
                                                                                
                 
                                         Solutions." <sqr-users@sqrug.org>      
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
               
                                                                                
                                                                                
                                                                                
               




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



-----------------------------------------
*************************** IMPORTANT NOTE *****************************
The opinions expressed in this message and/or any attachments are those of
the author and not necessarily those of Brown Brothers Harriman & Co., its
subsidiaries and affiliates ("BBH"). There is no guarantee that this
message is either private or confidential, and it may have been altered by
unauthorized sources without your or our knowledge. Nothing in the message
is capable or intended to create any legally binding obligations on either
party and it is not intended to provide legal advice. BBH accepts no
responsibility for loss or damage from its use, including damage from
virus.
************************************************************************


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