Re: Way to get list of databases ?

Jeff White writes: } Does someone know of a way (easy or not, but needs to be executeable } from command line, not interactive) to return a list of all the available } databases? Well, someone does. From Ken Evilsizor a little while ago: } > A week ago I posted a request for info on how to get a list of available } > databases into 4GL program using On-Line 4.0. I am assuming that they are } > stored in a table in rootdbs. } } There is a function called sqgetdbs() that can provide the information that } you request. While attending an OnLine for Database Administrators class } we received a listing for 'prlogdb' written by Jim McCann, Informix and } crediting Mark J. of Informix for the dbnames code. I will post the } dbnames function if Informix doesn't mind. } } --------------------------------------------------------------------------- } Ken Evilsizor Email: sdrc!cinnet!carsinfo!ken } CARS Information Systems } 4000 Executive Park Dr. Disclaimer: All opinions expressed are } Cincinnati, OH 45241 definitely my own. I get the feeling that this *hasn't* been posted, but that you'd get a fair way by playing with sqgetdbs(). Otherwise, mail him & grovel ;-) Cheers - Tony. _________________________________________________________________________ Tony Heskett th@bnr.co.uk Phone: (+44) 279 402637 BNR, London Road, Harlow, Essex CM17 9NA Fax: (+44) 279 451434