Curt Russell Crandall wrote:
> Is the DBI->data_sources method the only facility available in the DBI to
> get a list of databases on a server? I'm trying to build a Perl/Tk
> application that would give me an interface similar to say RapidSQL where
> I can have a frame containing a list of all the databases on a
> server... by clicking one, I can enter that database and issue commands
> and stuff. Sybase won't return anything with data_sources and I'm not
> sure if Informix will either... those are the 2 dbs I'm concerned with at
> this moment. I know in Sybase I could just query the master..sysdatabases
> table to get this list, but I was hoping there'd be a more portable method
> available in the DBI especially since I don't know what command to issue
> in Informix to get a similar list.
Have you tried using data_sources with DBD::Informix? If you don't have it,
you must have a really, really, really ancient version of DBD::Informix and
you are three to four years overdue for an upgrade. Check the test --
t/t??dblist.t IIRC. And/or the documentation?
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
