Re: Porting SQR to UNIX

[gadiy@sun4.miti.com]

     Howard,
     
     Many users use a database table to keep track of report requests. A 
     status field is updated at the end of the report to indicate that it 
     is finished.
     
     Another idea -- SQR can fire-off your process -- the one that must 
     wait for the report to finish. Using the "CALL SYSTEM USING" command 
     you can start the overnight process.
     
     I'm not sure if I'm hitting the target with these ideas. Perhaps if 
     you'd give some more specifics of how you run these jobs, I could 
     offer more ideas.
     
     Gadi Yedwab
     MITI


______________________________ Reply Separator _________________________________
Subject: Porting SQR to UNIX
Author:  usa.net!sqr-users@netcomsv.netcom.com at Internet
Date:    4/17/95 9:35 AM


SQR user,
     
My company has been using SQR for Windows with Sybase for a year the time has 
come to move some complex reports to run on UNIX (HP-UX).
     
We have a long running task that runs unattended overnight.  My SQR report runs 
in the middle of this, so it is vital that we control how it starts and stops. 
We have to be able to initiate the report from the client and the overnight 
process must wait until the report is finished before continuing.
     
Has anybody out there ever done anything like this before?  How did you do it?
     
Any comments or suggestions would be appreciated.
     
Howard Nelson
Phoenix International