Fairly new to Client Access

[Guest.Visitor]

You have a few options for this. The RUNRMTCMD command will allow you to run a program (in this case the CA data transfer) on a PC from the 400. The other option would be to script an FTP session from the 400 and FTP the file rather than using the Client Access transfer. This option would require that you have an FTP server running on the network server.

[EDIguru]

I have more or less tinkered in the past with downloading AS400 files with Client Access to the hard drive on a PC that was running Windows 95 and then to a zip file on floppy in Excel format. I would now like to learn more. We recently installed a PC Network using Windows XP and now we are going to begin downloading some sales data to a shared folder on the network as opposed to a floppy. The data comes in via EDI and I have it loading to a physical file on the 400. I would like to automate this process so that I don't have to have an operator manually kick it off every Monday morning. I have been working on an AS400 for 7 years now so I have experience with CL code, but not with some of the commands I've seen suggested here for what I want to do. I could probably hit and miss try some of these commands and get something to work, but I wonder if there is a better approach--a resource somewhere that can get me started off right or some direction for a beginner? I'm familiar with writing job schedule entries to kick off a CL, I just need to know where to go from there in the CL to start the Client Access data transfer. Any help will be appreciated. Thanks.

[S.Mildenberger]

You may want to look at command CPYTOIMPF for creating the file and store it in the QNTC file system. QNTC will show shared network drives form other servers on the network such as your XP server. To access the file share in QNTC requires the user id and password match between the two systems. Scott Mildenberger