This DOS .bat file automates download of order header and detail extract files from As/400 and writes them in Excel format on PC server using Client Access. A detailed log is written to history.log.
PHP Code:
rem This batch file transfers 2 files (Order Header Extract and Order Detail Extract)
rem for Acme Fireworks Company
rem Created by: W_E_COYOTE
rem Date: November 23, 2006
rem pour service voir Pierre
rem use cwblogon.exe to force a username/password temporarily into cache so script can run fully unattended. (eg: in PC job scheduler)
C:\Progra~1\IBM\Client~1\cwblogon.exe server /U usr /P Psw
rem: perform download of Header Records with client access batch download program RXFERPCB.EXE
echo
echo @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ >> history.log
echo Start Header file...... %date% %time% >> history.log
rem: Delete file before download. (In case server application is still holding file, your @#%@#%@#% is covered by log file)
delete F598019.xls >> history.log
C:\Progra~1\IBM\Client~1\RXFERPCB.EXE F598019.dtf USR PSW >> history.log
echo End Header file........ %date% %time% >> history.log
echo --------------------------------------------------------------------- >> history.log
rem: perform download of Header records with client access batch download program RXFERPCB.EXE
delete F598119.xls >> history.log
echo Start Detail file...... %date% %time% >> history.log
C:\Progra~1\IBM\Client~1\RXFERPCB.EXE F598119.dtf USR PSW >> history.log
echo End Detail file........ %date% %time% >> history.log
echo @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ >> history.log
Comment