RE: Unix cron job - executing informix 4GL process

Scott O'Rourke wrote: >Which OS? > >cron usually executes scripts with a Bourne shell (you'll get a warning after running crotab -e), unless you explicitly add something like #!/bin/ksh as the first line of your script. > >-----Original Message----- >From: informix-list-bounces@iiug.org >[mailto:informix-list-bounces@iiug.org]On Behalf Of yy4 via >DBMonster.com >Sent: 26 June 2006 10:16 >To: informix-list@iiug.org >Subject: Unix cron job - executing informix 4GL process > >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 > I am using UNIX-HP. In my scripts, the first line already stated #! /usr/bin/ksh. Any other clue to resolve this? -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200606/1