Re: cron job (SCO) and INFORMIX
In article <42m5iq$bd2@news.map.com>
gburnore@garys.arasmith.com "Gary L. Burnore" writes:
> olded@ix.netcom.com (Ed Schaefer ) wrote:
>
> >In <kcjDEHp8r.GGs@netcom.com> kcj@netcom.com (Kate Juliff) writes:
<snip> >
> >I think this only works as such:
> >
> ># set the environment, INFORMIXDIR, DBPATH, etc
> >dbaccess <db-name> -qcr sqlscript.sql
> >
> You'll also need to specify the LOCATION of the executable. The cron has no
> idea where the item is. The best way to do this is to use the full pathname to
> the executable. If you need to run different vsns, use the INFORMIXDIR variable
> you set earlier:
Better done by 'PATH=$INFORMIXDIR/bin:$PATH', rather than by using
explicit path. My choice would be in crontab:
<cron details> my_cron -i <informix-dir> -t <type> -s <script>
where 'my_cron' is a script in '/usr/bin' which works it's way
through the arguments using them to setup the Informix & Unix
environment, finally runnning the 'script' against the correct
program as indicated by '-t'.
Easy to alter when testing new Informix etc. and I prefer passing
parameters & arguments to setting hardcoding it all in the script.
--
============================================================================
Sally Woolrich | This mail contains my personal
sally@excelsis.demon.co.uk | views not those of my employer!
============================================================================