RE: Automated dialing to PCs w/data transfer

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

FTP does have a quote option...  I've not had the chance (or need) to use
it, but I know I've read of people that have on comp.sys.ibm.as400.misc.

Bradley V. Stone
Taylor Corporation - OASIS Programmer/Analyst   
bvstone@taylorcorp.com


> -----Original Message-----
> From: Rob Marssdorf [SMTP:Rob@cascade400.com]
> Sent: Friday, November 27, 1998 3:25 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      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
> +---
+---
| 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
+---