Re: running SQR (produces reports) on Unix box

["Lynds,Rick" <rlynds@MWD.DST.CA.US>]

We use a scheduled job to FTP our report files from UNIX to a non-Unix
network server, which then converts them to word (or excel, etc) and
distributes them to other non-Unix network servers.  This was all
home-grown, but its pretty simple and works reasonably well.

-----Original Message-----
From: Lambert, Jin [mailto:JLambert@HRBLOCK.COM]
Sent: Monday, July 10, 2000 11:57 AM
To: SQR-USERS@list.iex.net
Subject: running SQR (produces reports) on Unix box


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