Re: Running Informix on Cron
Posted in 1995
>From: Sally Woolrich <Sally@excelsis.demon.co.uk> >Date: Mon, 30 Oct 95 17:47:12 GMT >X-Informix-List-Id: <news.18413> >>Date: Tue Oct 24 08:46:04 1995 >>From: johnl@informix.com (Jonathan Leffler) >>>From: Stephen Wakeford <ad31@ns.cityscape.co.uk> >>>Date: Fri, 20 Oct 1995 20:57:19 +0100 >>>X-Informix-List-Id: <news.18126> >>>Does anyone know of a FAQ on running informix in cron scripts? >> The rules are very simple: >> (1) The program should not rely on having a terminal connected. >> (2) The environment needs to be set correctly. >> Item (1) means, in general, that I4GL programs using INPUT or other screen >> mode operations (including DISPLAY AT) are unreliable, but plain DISPLAY >> statements and reports are fine. >[more good info snipped] >We have also had problems with programs using the 'OPTIONS' statement >when run fron 'cron'. Problems can manifest themselves as >i) program not loading >ii) program core dumping >iii) program looping endlessly! Many of the OPTIONS (all the key stroke ones for sure) put the terminal in screen mode, and therefore come under the aegis of Rule 1. However, the OPTIONS statement should be (have been) cited explicitly in the commentary. Mea Culpa. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>