home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #16 / NN_1992_16.iso / spool / comp / database / informix / 1618 < prev    next >
Encoding:
Internet Message Format  |  1992-07-28  |  1000 b 
  1. Path: sparky!uunet!gatech!darwin.sura.net!jvnc.net!netnews.upenn.edu!netnews.noc.drexel.edu!coe.drexel.edu!jeff
  2. From: jeff@cbis.ece.drexel.edu (Jeff White)
  3. Newsgroups: comp.databases.informix
  4. Subject: Way to get list of all databases?
  5. Message-ID: <1992Jul28.155440.29855@cbis.ece.drexel.edu>
  6. Date: 28 Jul 92 15:54:40 GMT
  7. Organization: Drexel University, ECE Department, Philadelphia, PA
  8. Lines: 13
  9.  
  10.  
  11.   Does someone know of a way (easy or not, but needs to be executeable
  12. from command line, not interactive) to return a list of all the available
  13. databases?  Someone pointed out that we should probably be running
  14. 'update statistics' on them each not, so tha tthe cost based optimizer
  15. will have accurate information.
  16.   I have come up with a filter script that will take the output of
  17. 'thcheck -pe' (Online 5.0) and return a list.  However, I would have
  18. thought that information would be available from within the database
  19. and not from an external program.
  20.  
  21.                     Jeff White
  22.                     jeff@cbis.ece.drexel.edu
  23.