Re: Automated dialing to PCs w/data transfer

[Rob Marssdorf <Rob@xxxxxxxxxxxxxx>]

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
+---