RE: Calling Report and Viewing Output from a PC

[janusz.prusaczyk@xxxxxx]

This solution can't be used in every case, but if you can replace your
report by results of SQL query you can use ODBC or Client Access' data
transfer to get it. You change data transfer to SQL view and write your
query. Then you can transfer data to text file or Excel where you can
process it with a macro. There is one hundred ways to get data though ODBC:
Delphi programs, Perl scripts, HTML pages using ADO etc. Once you have basic
script you change SQL statement in a few minutes. This works much slower
than running query on AS/400, but I think user can wait 2 or 3 minutes for a
report - it is still quicker than asking operator to print it.

I have a question to everyone: How can I programatically access spool file
text not copying it to physical file? Is there a way to do it from a Perl
script running on a PC?

Best regards,

  
  ********************************************
    Dawid Janusz Prusaczyk                    
    Janusz.Prusaczyk@big.pl                   
    tel. +48 (22) 657 57 48                   
  ********************************************

  "Experience is what you get when you didn't get what you wanted"


-----Original Message-----
From: Joe Giusto [mailto:JGiusto@patuxent.com]
Sent: Wednesday, April 26, 2000 5:33 PM
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
+---