Re: UNIX Scripts Run In Cron

In article <51s5dn$t78@cssun.mathcs.emory.edu>, 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 > We had a similar problem some time back. In our case, we discovered that the DBPATH variable had not been set. Add your .login environment settings to the script being called by cron. Hope this helps. Rudy