RE: Calling Report and Viewing Output from a PC

If you don't specify userid, job number, etc.. it will look in the current
job.  You'll need all that info.  You can't use the defaults for job with
CPYSPLF and FTP.  (ie * for job, *LAST for spoold file number, etc..)

Brad

> -----Original Message-----
> From: Joe Giusto [mailto:JGiusto@patuxent.com]
> Sent: Friday, April 28, 2000 8: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
+---