Re: Invoke PC Access program from an AS/400

[Bob Larkin <blarkin@xxxxxx>]

Two possibilities
FTP. Use FTP to PUT the file on the PC, then use the QOUTE statement to execute 
te program on the PC to merge the data into the database. I have used this to 
transfer large files to an outside printing house, then kick off their 
processing.

ODBC - get that darn file off the PC, put it on the AS/400 using NetServer, let 
the PC connect to the database thru an ODBC connection, while you write 
directly to the file. There was a good article in a recent Network Expert 
journal from News/400 on just this type of setup.

Bob
Denis Robitaille wrote:

> Hello all,
>
> Here is my problem. I have a program on an AS/400 that is used to receive raw 
>material. Each time a reception is accepted, I must find a way to transfer it 
>to an access database located on an NT server. The transfer must be close to 
>real time because the material just received may be used in the following 
>minutes and the comsuption program is in access. I was planning to do the 
>following:
> 1- Add a trigger to the reception file to trap any changes
> 2- add the information that need to be transferd to a work file (or data 
>queue, or whatever)
> 3- have the AS/400 evoke a command on one PC attach to the AS/400
> 4- The PCcommand would be an access program to download the work file, add 
>its information to the data base and then clear the work file
>
> My problem is with step 3. What are the possible alternative? what do you 
>suggest?
>
> Denis Robitaille

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