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

Sorry for the duplicate message, I forgot to include  my output results in
the last post.

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.

220 Connection will close if idle more than 5 minutes.
ftp> user ftp xxxxxx
331 Enter password.
230 FTP logged on.
ftp> quote rcmd CHGLIBL LIBL(QTEMP QGPL q400f arlib ionew) 
250 Command CHGLIBL LIBL(QTEMP QGPL q400f arlib ionew) successful.
ftp> quote rcmd CALL splstoffc2 
550-Error occurred on command CALL splstoffc2. 550 Error found on CALL
command.. ftp> quote rcmd CPYSPLF FILE(arprt10) TOFILE(arlib/SPOOL)
550-Error occurred on command CPYSPLF FILE(arprt10) TOFILE(arlib/SPOOL). 550
File ARPRT10 not found in job 251071/QTCP/QTFTP00592..

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> 


Get paid to surf the web!
http://www.alladvantage.com/home.asp?refid=BBH-718
<http://www.alladvantage.com/home.asp?refid=BBH-718> 
The rules have changed!

-----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
+---


+---
| 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
+---
+---
| 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
+---