Transfer MS Access Table to the AS/400

[Guest.Visitor]

I hope someone can help with this. I need to initiate a file/table transfer from a PC/LAN to the AS/400 from a AS/400 menu option. My client does not want to push "anymore than one button on the AS/400". My exposure to SQL is nill and researching the IBM manuals is getting frustrating. Your help with this would be extremely appreciated!!

[Guest.Visitor]

You can use the AS/400 Client Access remote command feature. This allows the AS/400 to call a program on the PC. You could also put an ftp server on the PC that allows remote command. With this you could write a script (ftp) to initiate a program call on the pc. You could also write a program using ODBC to extract info from the MS Access table to the AS/400 with the 400 ODBC driver. Setup a script file transfer in Client Access/400 or ftp from the client to the AS/400. The way you can call a remote command or program over ftp is "quote rcmd call program". With ftp it is better that all of your fields are fixed width. If you need exact code please let me know. These are only the ways of remote execution.

[Guest.Visitor]

Dan, I would appreciate any code pertaining to coding a program using the ODBC driver.

[Guest.Visitor]

You could also use the commands (in CL) STRPCO STRPCCMD to run the RFRMPCB programs that come with CA/400.