Copying AS/400 data to the PC clipboard

[Guest.Visitor]

Calling a PC program from CL is easy via STRPCCMD, but how do you pass data back and forth? Automatically importing and exporting a file may be one solution but then I thought it might be quicker to dump it onto the clipboard as a text file or even a CSV file. I would like to call an Access form (.exe) and manipulate data then return it to the AS/400. Any ideas?

[Guest.Visitor]

One way to get data from an AS/400 screen is to use a CL command to copy screens to a file. Issue the STRCPYSCN command (which requires user response to authorize); when the screen(s) you want have been captured, issue the ENDCPYSCN command to stop. Your PC program can transfer the file and use it as input. Command example: STRCPYSCN SRCDEV(*REQUESTER) OUTDEV(*NONE) OUTFILE(library/member) + OUTMBR(member) Alternatively, you can write a Client/Access macro to copy screens to the clipboard for you. I have experimented with a PC-based perl script that reacts to information found on the clipboard. I don't know how you will send data back to the AS/400. Automatic pasting by a Client/Access macro would be tricky because absolute positioning of the cursor is difficult. Hope this helps.

[Guest.Visitor]

We have a product called FTP Remote Command Server that allows you to pass clipboard data and more between an AS/400 application and the PC. It's a great tool for integrating an AS/400 application with the PC. For more information check out our web site or contact me directly. Regards, Richard Schoen RJS Software Systems Inc. "The AS/400 Report and Data Access Experts" Email: richard@rjssoft.com Web Site: http://www.rjssoft.com

[Guest.Visitor]

From the PC, can you map a drive to the 400 IFS? bobh