Re: dbaccess - List all database created in server

Low Are you using Informix SE? If yes, you need to add the location of the database you cannot see from dbaccess to the environment variable DBPATH. HTH Sujit "Peter J. DiFondi" <pdifond1@nycap.rr.com> on 12/16/99 06:46:44 PM Please respond to "Peter J. DiFondi" <pdifond1@nycap.rr.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Re: dbaccess - List all database created in server The message is a little unclear...but....I think you might want to take a look at groups in the sqlhosts file. There is a very good description in the Sys Admin manual. PJD Low Kit Ming <kmlow72@hotmail.com> wrote in message news:385997BC.E6A3A92F@hotmail.com... > Hi all, > Quick questions about dbaccess, hope you can helps :o) > > How could I list all the databases that resided in a particular dbspace > (rootdbs) on network drive, if i doesn't have any DBA privilege? For > instance, a new database was created but the database name doesn't > appears on the dbaccess->select screen. However, i still can select the > database and run my sql statements on dbaccess->query-language. Why? > > Thanks you in advance > > -Novice >