Unix cron job - executing informix 4GL process
Posted in 2006
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
I am facing some problem while executing the process thru cron. My execution scripts (KORN shell) will be something as below: echo U$(tput kf9)$(tput kf9)|/prog/bin/prog1.exe M A 1>/prog/log/cron.log In my cron.log, I can see that the 1st input parameters is not passing in to the program correctly therefore it is prompting invalid entry. However, when I execute the program manually thru command line,it is working fine. Anyone have any clue what cause the problem? /prog/log/cron.log details: --------------------------- ENTRY TO CREATE THE IMP AND LOG ACCOUNTS "ADD" FILE, ENTER 'A' O R TO CREATE THE IMP AND LOG ACCOUNTS "UPDATE" FILE, ENTER 'U' OR TO PREPAR E THE "ADD" OR "UPDATE" FILE FOR FTP TRANSMISSION, ENTER 'S' ENTER YOUR CHOICE.. . (A/U/S) prog.exe/01 A. A. A. DATE 26/06/2006 VERSION 6.7.00 CREATE/SAVE IMP /LOG FILE FOR IBS F7 CANCEL / F9 ACCEPT ^HU^HH^H Invalid entry Invalid entry Invalid entry Invali d entry Invalid entry -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200606/1
> I am facing some problem while executing the process thru cron. My execution > scripts (KORN shell) will be something as below: > echo U$(tput kf9)$(tput kf9)|/prog/bin/prog1.exe M A 1>/prog/log/cron.log > In my cron.log, I can see that the 1st input parameters is not passing in to > the program correctly therefore it is prompting invalid entry. However, when > I execute the program manually thru command line,it is working fine. > Anyone have any clue what cause the problem? When you execute it manually via a telnet/ssh session you probably have a TERM value set, which defines that `tput kf9` outputs. When it runs via CRON then TERM is possibly not set or set to some system default. Try - (export TERM=vt100; echo U$(tput kf9)$(tput kf9)|/prog/bin/prog1.exe M A) >/prog/log/cron.log