Re: cron job (SCO) and INFORMIX

olded@ix.netcom.com (Ed Schaefer ) wrote: >In <kcjDEHp8r.GGs@netcom.com> kcj@netcom.com (Kate Juliff) writes: >> >> >>I need to run a shell script that calls dbaccess, sacego and ISQL. >I've >>set it up so that it sets all the environment variables and the path, >yet >>I still get an error from cron that the executables can't be found. My > >>script is of the form >> >>SET INFORMIXSERVER mecho_s; export INFORMIXSERVER >>etc. etc. >> >>dbaccess pic xxx >>ISQL xxx >> >>Can anyone help? >> >>Thanks, >> >>Kate >> >Kate: > >I think this only works as such: > ># set the environment, INFORMIXDIR, DBPATH, etc >dbaccess <db-name> -qcr sqlscript.sql > >You can run this from the command line, cron, or some other program or >shell script. 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: /usr/informix/bin/dbaccess - whatever or $INFORMIXDIR/bin/dbaccess - whatever