Re: Invoke PC Access program from an AS/400

Denis, one possibility would be to write the program with Visual Age RPG. 
That would allow you to access AS/400 information and write/update PC data 
at the same time, allowing it to all be tied into one process.  The 
program itself would have to run on a Windows machine, or on a device that 
is Java enabled. 
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"Denis Robitaille" <DRobitaille@cascades.com>
Sent by: owner-midrange-l@midrange.com
11/16/1999 01:44 PM
Please respond to MIDRANGE-L

 
        To:     <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        Invoke PC Access program from an AS/400

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
Directeur service technique
Cascades Inc
819 363 5187
fax 819 363 5177

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