RE: Calling Report and Viewing Output from a PC

They couldn't see any reports they couldn't see from 
a green screen with command line access and LMTCPB(*NO).  
If you're concerned about the spool files, then you can 
secure the output queues.

However, I believe that Op's nav requires Client Access 
and he wanted to avoid that.  The user would click on an
icon, the program would run and the report would display.





wawrzaszeka@AUSTEEL.com on 04/27/2000 08:28:58 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

If the user can use AS/400 ops navigator, they can just click on the basic
operations, and printer output to see any of their reports.  Or if it goes
to a certain printer if they just click on that printer they would see all
output for that printer.  However this does pose a problem in that they can
get to any report out there through this method which may not be a good
idea.  

Angie Wawrzaszek
M.I.S. Department


-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Joel Fritz
Sent: Wednesday, April 26, 2000 6:45 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Calling Report and Viewing Output from a PC 


Kinda depends on what you have available and how fast you need this.

Are these interactive, on demand reports, or output from a batch process?
Sounds like the former.

The easiest might be copying the spooled file to a data base file and
copying that to a text file in the IFS with cpytoimpf or cpytopcdoc.  This
means the end users have to have access to the IFS.  They could view the
reports in notepad or the editor of your choice.  This is the quickest and
dirtiest.  You could do it in a batch file.  Execute the remote commands on
the 400 and then invoke the editor on the PC.

There's the intranet solution, assuming you have the HTTP server up.  With
net.data you could throw together something together that would take a bit
longer, but would offer cosmetic advantages. CGI RPG would take longer
(unless you're already good at it) but might do better.

If you just want to display spooled files as HTML, News 400 had an article a
couple of years back with code to copy a spooled file to a data base file
and run it through a program that inserted a minimal set of HTML tags.  We
use that for a couple of daily reports.  I wouldn't recommend it for
something that was more than a couple of pages long, unless you wanted to
modify it to make it more user friendly.

Another approach would be a query tool on the PC that uses ODBC.  That means
spending money and taking some precautions against the many to many join
that kills the host system.

Good luck.  

 

> -----Original Message-----
> From: Joe Giusto [mailto:JGiusto@patuxent.com]
> Sent: Wednesday, April 26, 2000 8:33 AM
> To: 'midrange-l@midrange.com'
> 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
+---