Id like to run a Client Access file transfer, which converts an excel file to EBCDIC and then uploads to an AS/400 physical file, in a batch environment.
CA Batch Data Transfer takes just a few steps to implement.
First, you need to run an interactive data transfer download from the Physical File (PF) to a PC data file. The PF should be the file that you will eventually upload the excel data to. On this step, make sure that you change the output device to FILE, specify the path and filename and then click the DETAILS button. On this screen make sure that the file type specified is that which you will eventually upload (in your case BIFF3 BIFF4 or BIFF5 depending on the Excel worksheet version you are saving the spreadsheet to). Also, make sure that the SAVE TRANSFER DESCRIPTION option is checked. This will create the FDF file which you will need for the next step.
Second, create a data transfer upload request. Specify the PC data file you wish to upload (the Excel file), the PF you wish to upload to (the one you downloaded from in the previous step), and then click the DETAILS button. Make sure the USE PC FILE DESCRIPTION FILE box is checked and that the name entered matches the FDF file that was created in the previous step. Make sure NO REPLACE MEMBER ONLY is specified in the create object section. Click OK out of DETAILS and run the upload.
Third, assuming that the upload ran successfully, save the transfer request to the hard disk drive.
Finally, from a DOS command line run the RTOPCB command with no parameters and hit enter. This will give you the usage for the command.
Likely you will eventually just call the RTOPCB command with one parameter; the name of the saved transfer request.
You can call this batch data transfer from a scheduler utility or from any batch program you have configured on the PC in question.