Re: How to retrieve a list of databa

Denham.M@amstr.com wrote: > > If you have V7 (possibly in later V5 versions too 5.06+), you can open the sysmaster > database on the server and read the names of the databases from sysdatabases. > > You will of course then need to connect to each of these databases silently to determine > if the user has permission to access the db before presenting the user with a list.... > if you want to avoid the user seeing the names of databases that they do not have perms to > access. > > Mark > MarkDenham@aol.com (home) > Denham.M@amstr.com (work) > --------------------------( Forwarded letter 1 follows )--------------------- > Date: Tuesday, 10 June 1997 3:04pm > From: pyurga@lucent.com (Paul Yurga) > Subject: How to retrieve a list of databases > Date: 10 Jun 1997 20:54:02 GMT > Reply-To: pyurga@lucent.com > Organization: Network Systems > Sender: informix-list-owner@rmy.emory.edu > To: informix-list@rmy.emory.edu > X-Informix-List-Id: <news.39013> > > How can I get a list of the available databases so that I can prompt a user for > the database with which to connect? I am writing a PowerBuilder app for this > purpose so if there is a PB specific way I'll take that as well. > > Thanks, > Paul Yurga > Lucent Technologies The Informix Database Administrator's Survival Guide has a simple ESQL/C script to return a list of database names.