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: > >> > >> > >>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 > >> The thing which I think everyone has missed (and which *I* forget every time I do some cron work) is that the SQL script must have a full path name: $INFORMIXDIR/bin/isql pic /usr/kate/dev/xxx will probably work. As long as you move xxx.sql to /usr/kate/dev .... :-) HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregende andersche kondom!