how to find all the database created in the informixserver

Posted in 2006

Danny De Koster — Wed, 13 Sep 2006 16:48:56 +0200 — source: Usenet: comp.databases.informix

Hi all, Another question. How can I find the name of all the databases created in the INFORMIXSERVER?? thanks, Danny

↪ replying to Danny De Koster

plumas4u via DBMonster.com — Wed, 13 Sep 2006 14:56:15 GMT — source: Usenet: comp.databases.informix

Run the following query against the sysmaster database: "select name from sysdatabases" and disregard the system cerated databases (sysmaster, sysutils, sysuser and perhaps onpload). -- Message posted via http://www.dbmonster.com

↪ replying to Danny De Koster

Floyd Wellershaus — Wed, 13 Sep 2006 08:04:41 -0700 (PDT) — source: Usenet: comp.databases.informix

echo "select name from sysdatabases"|dbaccess sysmaster ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: Danny De Koster <ddk@fidelity-soft.be> To: informix-list@iiug.org Sent: Wednesday, September 13, 2006 10:48:56 AM Subject: how to find all the database created in the informixserver Hi all, Another question. How can I find the name of all the databases created in the INFORMIXSERVER?? thanks, Danny _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list