RE: Unix cron job - executing informix 4GL process

Posted in 2006

Rob Konikoff — Mon, 26 Jun 2006 15:24:09 -0400 — source: Usenet: comp.databases.informix

It also looks like it is looking for a parameter/switch. When executing from cron, you must specify all aspects of the operating environment. Cron doesn't know much about anything if you don't tell him. Rob -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Scott O'Rourke Sent: Monday, June 26, 2006 7:09 AM To: yy4 via DBMonster.com; informix-list@iiug.org Subject: RE: Unix cron job - executing informix 4GL process 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 -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200606/1 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list