Re: Calling Report and Viewing Output from a PC

Joe,

I expect you'll find the full text of your erro message in job
251071/QTCP/QTFTP00592 and not in QPRTJOB FTP 250353.  QPRTJOB FTP
250353 is just the process to which the printing get's charged. 
The actual work is done in 251071/QTCP/QTFTP00592.

jte

Joe Giusto wrote:
> 
> >From the command line, the CPYSPLF works fine.  It has something to do with
> the spooled file get attributes that say it comes from job QPRTJOB FTP
> 250353 and the CPYSPLF gives error indicating that spooled file not found in
> job 251071/QTCP/QTFTP00592 when run through FTP RCMD.
> 
> I have inserted a CHGJOB to log 4 00 *SEVLVL, but there is no JOBLOG
> produced in job QPRTJOB FTP 250353.
> Although when I do a WRKJOB on QPRTJOB and try to look at the job log, it
> says job has ended.  But the next time I run the FTP batch file, the new
> spooled file ends up in the same job 250353 that is said to be ended.  When
> I delete all the spooled files for job 250353, it still comes up on the
> WRKJOB screen.  Any other job goes away from the system when I delete all
> the spooled files.  This seems to be unusual behavior.  I assume the jobs
> are treated differently because they are created from the FTP session.  (can
> anyone shed some light here?)
> 
> 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:   Friday, April 28, 2000 12:18 PM
> To:     MIDRANGE-L@midrange.com
> Subject:        RE: Calling Report and Viewing Output from a PC
> 
> Can you call the CLP from a command line and see if the CPYSPLF works?
> Change you job to log like crazy and let's see the joblog.
> 
> JGiusto@patuxent.com on 04/28/2000 09:22:50 AM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:     MIDRANGE-L@midrange.com@Internet
> cc:
> Fax to:
> Subject:        RE: Calling Report and Viewing Output from a PC
> 
> 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
> +---

--
John Earl                               johnearl@400security.com
The PowerTech Group                     206-575-0711
PowerLock Network Security              www.400security.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
+---