Re: running SQR (produces reports) on Unix box

[Arjan Hoornstra <ahoor@YAHOO.COM>]

SQR running on Unix is never a problem... also the ftp
part, the best way toi do this is let SQR take care of
this with a 'call system' function.
If you have access from your Unix machine to NT you
can have the .lis file created there using the -F
function. (for example sqr -F
//NTSERV01/lisfiles/report.lis)

You can also make sqr write a ftp-commandfile and on
the Unix server make a batchfile which first executes
the sqr and then ftp's using the command file (-n
option). For a .lis file this is probably the best.

Arjan


--- "Lambert, Jin" <JLambert@HRBLOCK.COM> wrote:
> Hi, all-
>
> I want to hear from your experts out there, about
> possibilities of running
> SQR reports on the Unix Server???
>
> (we are on SQR V4.3.4, Peoplesoft 7.52 application
> with 7.58 tools, the Unix
> server HP-UX 11.0 , the NT server 4 SP 5 and SP 6A)
>
> Current situation in our shop
>
> *       For any sqr report processes, if they are
> not producing any .lis
> file (reports) we will try to run them on Unix box
> (Server) to improve
> performance.
>
> *       For any sqr report process producing any
> type of .lis file
> (reports), we are forced to run them on Client so
> any produced reports
> (.lis) can be either printed (LPT1), or resided on
> the local drive (C: ) or
> the network drive (NT) somewhere.
>
> Desired situation
>
> *       We would like to utilize Unix serve's horse
> power but not sure the
> followings-
>
> *       If the sqr runs on the Unix, then all
> reports will be generated in
> the Unix directory, how do we efficiently ftp
> reports back to the NT network
> drive?
> *       Is any software in the market, which allows
> sqr running on Unix to
> produce reports on the NT side (instead of Unix
> side)
> *       What are your experiences and suggestions?
>
> -JL


__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/