Re: Automated dialing to PCs w/data transfer

Do you prefer to push it to the client from the host, or can you pull it
from the host when the client connects in?

I'm thinking FTP or a VB app, but I have no idea what sort of software
you've got available (DOS, W3.1,W95,PCAnywhere, etc) or if you have
security issues (hence the push approach).

I think dropping or picking up the file is possible - running the Access
app is where I'd be stuck - is there a remote cmd in FTP?  QUOTE?

Interesting goal.  I'll be following this thread.

Rob




At 03:24 PM 11/27/98 -0500, you wrote:
>We would like to be able to write an application for the AS400 to do the
>following:
>- dial into a PC at a remote site
>- download database files to the PC
>- run an Access application on the PC
>- upload database files to the AS400
>- report any part of the process that was unsuccessful
>- repeat the above steps for multiple sites
>
>Some background:  The PC application that is using the data was created with
>Microsoft Access, therefore the data is stored in Access tables.  I'm
>imagining that the data may need to be exported to text files on the PC for
>uploading to the AS400.  The uploaded data will need to be appended to an
>AS400 database file for processing.
> 
>We have a process in place now to do the above but it is a very unautomated:
>We're using a PC using PC Anywhere to dial into the remote site's PC.  The
>host PC has an Access database to accumulate uploaded data, which is then
>appended to AS400 files via ODBC.
>
>We would like to eliminate the intermediate PC used to dial into the remote
>site and have the AS400 manage the whole process.
>
>I'm looking for ideas, internet sites, books, or anything that will bring me
>closer to implementing the above.
> 
>
>+---
>| 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
>+---
>
>
=======================================================
http:\\www.cascade400.com       IBM AS400 User Group    
mailto:rob@cascade400.com       Portland, Oregon 
=======================================================
+---
| 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
+---