Re: Newbie question

From: David Kulkarni <dnk61@yahoo.com> > >Can somebody give me suggestions on how to run update >statistics on per table basis via a cron. This in on >Informix 5.10uc5 version running on HP-UX 10.20. INFORMIXDIR=... PATH=... for i in `echo "select tabname from systables where tabid > 99 and tabtype = 'T'" | dbaccess yourdb | grep -v tabname | grep [a-z]` # above should be on one line do echo "update statistics for table $i" | dbaccess yourdb done ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com