Re: Running Informix on Cron

In article <46j3t8$2nq@cssun.mathcs.emory.edu> johnl@informix.com "Jonathan Leffler" writes: > >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 (Solaris > >2.4)? We want to run some batch progams overnight. > > The Informix FAQ does not have any significant information on running > Informix programs under cron -- Kerry, please note. > > 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. ISQL can be run in the batch mode to > interpret SQL scripts, and to run ACE reports (or to compile reports or > forms), but running forms or using menus or the schema editor, etc, is > error-prone at best. > <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! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================