Re: databases to databasespace

Helmut Leininger wrote: > > Peter Shankey wrote: > > > 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? Select * from sysmaster:sysdatabases; The first 12 bits of the partnum column are the dbspace number which can be looked up in sysmaster:sysdbspaces. For full details and example code get my submission to the IIUG Software Repository named utils2_ak and look at the code for listdb7.ec which is part of that archive, or just compile and run that program. Art S. Kagel