RE: SQL command for database list
Assuming IDS 7.x or greater . . . . within dbaccess, try
database sysmaster;
select owner, name
from sysdatabases
John Carlson
Informix Database Administrator
EDS - WHSmith USA
3200 Windy Hill Road, Suite 1500 West
Atlanta, GA 30330
-----Original Message-----
From: Bob Olson [mailto:norseman_79@yahoo.com]
Sent: Monday, December 11, 2000 1:48 PM
To: informix-list@iiug.org
Subject: SQL command for database list
Can someone please give me the SQL command to get a list of database
names and their owners from an Informix server? We use this server as
part of our build process, and we periodically fill up the database
space on the server and have to remove old databases. I'd like to send
out this database list to all our users to have them remove their
databases.
Thanks in advance,
Bob Olson
Sent via Deja.com http://www.deja.com/
Before you buy.