Re: pc support on as.

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Here's a suggestion: modify your PC batch file to call a CL program on the
AS/400. The CL program will then run the query and do the download (your
current method initiates the download from the PC; this way would
essentially reverse that and initiate it from the AS/400). I don't have
code in front of me right now, but I could help you with some of the
details if you like -- we have routines here where CL programs fill files
on the AS/400 and then download them to the PC. In our case, the files are
filled based on user input from an interactive program on the AS/400, so
it's a little different, but I think the basic idea should still work. . .
.

hth

MIDRANGE-L@midrange.com writes:
>good day! i just would like to ask. i have a query program and its output
>is not print but database. and i would like to get that database file
>saved on my pc with an excel or csv extension. i have tried client access
>and it is doing fine but i want to create a batch file over my desktop,
>once it is clicked it automatically calls the query program on the as and
>later it will then download the database file on the pc(desktop area).
>the batch file i have tried right now is simply logging into the AS thru
>ftp and then downloads the spool file but first i have to make changes on
>the AS before i will call that batch file.
>Is there any solution for this so that i do not need to go into my query
>program over the AS and manual download the database using the created
>batch file over the pc?
>
>Any ideas, i really need help for this.
>
>Thank you.
>
>jvy



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.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
+---