RE: Calling Report and Viewing Output from a PC -- MIDRANGE-L

I like this solution.  However, I am having trouble with the CPYSPLF part.
I have tried CPYSPLF in the FTP Script and in the CLP.  In each case, I get
a spooled file not found error.  I look at the spooled files for user FTP
and it is there.  I have noticed that the FTP message has returned "... not
found in job 251071/QTCP/QTFTP00592"  so I imagine that the CPYSPLF is
looking for the spooled file in that job instead of the job indicated by the
spooled file I saw created on the system.  Here is a copy of the output
results.

Joe Giusto II
Patuxent Publishing Company
10750 Little Patuxent Parkway
Columbia, MD 21044
mailto:JGiusto@patuxent.com <mailto:jgiusto@patuxent.com> 
http://www.lifegoeson.com <http://lifegoeson.com> 



-----Original Message-----
From:   Rob Berendt [SMTP:rob@dekko.com]
Sent:   Wednesday, April 26, 2000 6:23 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: Calling Report and Viewing Output from a PC

There is a danger of how long this job takes.  For example 
if it takes several minutes to generate the report then the 
FTP session may time out and you'll have to reconnect.  This 
may be a problem.  Why?  Because I suspect that you are 
embedding the ftp signon into the batch file and you are not 
differentiating it by user.  I suspect you are using the same 
ftp userid and password for every user.

If you aren't having the time out problem then you might try 
the following in your pc batch file:
ftp -n -s:script.txt >ftpout.txt
notepad spool.txt

And in your script file:
open myas400
user myuser mypwd
cd myfilelib
quote rcmd CHGLIBL LIBL(QTEMP QGPL myfilelib mypgmlib)
quote rcmd CALL MYPGM
quote rcmd CRTPF myfilelib/spool RCDLEN(150)
quote rcmd CPYSPLF FILE(MYPGMO) TOFILE(MYFILELIB/SPOOL)
get myfilelib/spool spool.txt
quit


If you use different user id's then MYPGM could be submitted 
off to batch and the report could be emailed back to the right 
person.  Or add a parameter to MYPGM which is their email address.  
You could use the Send Mail API or the numerous offers you're 
about to be flooded with.






JGiusto@patuxent.com on 04/26/2000 05:02:38 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:      
Fax to: 
Subject:        Calling Report and Viewing Output from a PC

We have recently eliminated an operator position, and I have now been asked
to take some of the reports and allow the users to view them on the PC by
clicking on an Icon on the windows desktop.
They do not want to have to bring up a Client Access session and log on to
run these reports.

I have started playing with FTP 's Quote RCMD and have had mixed results.
I am able to get a program to run that generates the spooled file, then I
get stuck on how to get it back to the PC user to be viewed on screen.

I would appreciate and suggestions from the list to help me out with ideas
on how to approach this.

Thank you,


Joe Giusto II
Patuxent Publishing Company
10750 Little Patuxent Parkway
Columbia, MD 21044
mailto:JGiusto@patuxent.com <mailto:jgiusto@patuxent.com> 
http://www.lifegoeson.com <http://lifegoeson.com> 



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---