data transfer from PC to AS400

[Guest.Visitor]

Hi, How can I automate a data transfer from a PC file (CSV) to the AS400 ? I have my Client Access Express tranfer request created (and tested). It is a .DTT file. I remember a long time ago, in PC Support days, I used the RFROMPCB command to do this in a .BAT file/program. Can I still do this ? Is there a better more efficient way ? Please be real specific because I cannot remember anything. I remember we even had to specify a STRRTR in the old days. Is this still needed ? Can anybody help me out ? Thank you very much !!! Jim Sovick

[Guest.Visitor]

We have just that sort of thing automated. Yes, the RFROMPCB and RTOPCB commands are still there. Here is some code from our automated upload job. Batch file called from an Excel macro @echo off rem this macro takes a formatted forecast.xls rem and uploads it to the AS400 then runs rem a CL on the AS400 to post to Future 3 cls cd"Program FilesIbmClient Access" rfrompcb "c:Forecastfcst2400.tfr" if errorlevel 20 goto error rmtcmd sbmjob cmd(call pgm(hilex/hxf3656c2) parm(%1)) goto end :error echo *** ERROR *** echo File transfer failed goto exit :end cls :exit cd Here is the fcst2400.tfr that is referenced TRFRPC TO HILEX/HXF3656C C:Forecastforecast.xls 19 C:FORECASTHXF3656C.FDF 32 1 SYSTEM S10A9833 0 PROPS 00011 Here is the HXF3656C.FDF that is referenced PCFDF PCFT 11 PCFO 1,1,1,1,1 PCFL CSTABR 1 6 PCFL HXPART 1 15 PCFL UNT1 2 9 PCFL UNT2 2 9 PCFL UNT3 2 9 PCFL UNT4 2 9 PCFL UNT5 2 9 PCFL UNT6 2 9 PCFL UNT7 2 9 PCFL UNT8 2 9 PCFL UNT9 2 9 PCFL UNT10 2 9 PCFL UNT11 2 9 PCFL UNT12 2 9

[Guest.Visitor]