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

Notice that your CALL splstoffc2 is failing.  If the spool file is created
in that program then that is why the spool file isn't found.  I think you
need to find out why the call is not working first.

Scott Mildenberger

> -----Original Message-----
> From: Joe Giusto [SMTP:JGiusto@patuxent.com]
> Sent: Friday, April 28, 2000 7:25 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Calling Report and Viewing Output from a PC
> 
> 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
> +---
+---
| 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
+---