Re: update statistics script

James Dont you need to do su - informix to set the environment from the .profile of user informix? HTH Sujit Obnoxio The Clown <obnoxio@hotmail.com> on 05/26/99 01:54:48 PM To: jswallow@greenbay.k12.wi.us, informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Re: update statistics script From: "James R. Swallow" <jswallow@greenbay.k12.wi.us> > >I am looking for a way to run update statistics script from cron against 4 >different instances. A script that includes user informix, environment >variables, and sql (dbaccess dbname xxx.sql). The ability to set >environment >variables after (su informix) seems to be hangup. Any help is appreicated. Sounds like you're looking for Art Kagel's dostats.ec. Head over to http://www.iiug.org and check out the software section. Art has two or three bundles of software, dostats is in one of them. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com