Re: UNIX Scripts Run In Cron

sheltra@emh-1.submepp.navy.mil wrote: > > I am running Informix 4gl and SQL programs in a script via a cron. The > job appears to be running properly with no aborts etc....however, when > I examine the Data Base and Tables that were to have been dropped and > recreated, I find that the status for the tables has not changed. The > SQL that drops the tables is written within the 4gl programs. When I > run the 4gl programs separately from the command line it works fine. > > Any ideas???? TIA > > e-mail: sheltra@emh-1.submepp.navy.mil Start with the obvious: is environment being set properly in the cron script? Cron has nothing but the most basic environment by default; you'll have to have a script that sets things like ONCONFIG, DBPATH, INFORMIXDIR, etc. The simpliest way to do it is to put the environment that works OK into a file: env > filename Then edit the file to set the necessary parameters. -- //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer