Re: databases to databasespace
En Peter Shankey va escriure el dia 8 Nov 98, a les 8:28:
From: Peter Shankey <shankeyp@charlestoncounty.org>
To: informix-list@iiug.org
Subject: databases to databasespace
Date sent: Sun, 08 Nov 1998 08:28:05 -0500
Organization: Posted via Supernews, http://www.supernews.com - Discussions start here!
Send reply to: Peter Shankey <shankeyp@charlestoncounty.org>
> it is my understanding that:
> a database can exist in one and only one databasespace.
> a databasespace does not have to have anything in it, but can contain temp
> space, logical logs and one or more databases.
>
> So, what would be the SQL on the system tables (sysmaster) which would
> tell me what database is in what databasespace?
>
> thanks
>
>
Use the above sql and enjoy:
select dbsname,dbinfo("DBSPACE",partnum)
from systabnames
where tabname="systables"
---------------------------------------
Isidre PONS ROCA
BASE - Gesti' d'Ingressos Locals
(Diputacio de Tarragona)
Servei de Sistemes de Informacio
Av President Lluis Companys 12-C
43005 - Tarragona
SPAIN
Tel # +34 977 236731
Fax # +34 977 227302
http://www.altanet.org
ipons@dtgna.altanet.org
---------------------------------------