Re: database location

select sysdatabases.name,sysdatabases.owner,sysdbspaces.name from sysdbspaces,sysdatabases where partdbsnum(sysdatabases.partnum)=sysdbspaces.dbsnum This will be useful for you SR At 10:51 AM 8/19/99 +0800, you wrote: >Would that be possible to retrieve each database location (Which >dbspaces ?) from the sysmaster database using a single SQL statement ? >The info. that required are :- > >1. Database Name >2. Dbspace Name > >Thanx in advance. > >Informix Dynamic Server Version 7.30UC3. > > >

Radhika wrote: > > select sysdatabases.name,sysdatabases.owner,> sysdbspaces.name from sysdbspaces,sysdatabases where > partdbsnum(sysdatabases.partnum)=sysdbspaces.dbsnum For earlier versions that do not have the partdbsnum procedure make the lastline: trunc(sysdatabases.partnum / 1048576) = sysdbspaces.dbsnum Art S. Kagel > This will be useful for you > > SR > > At 10:51 AM 8/19/99 +0800, you wrote: > >Would that be possible to retrieve each database location (Which > >dbspaces ?) from the sysmaster database using a single SQL statement ? > >The info. that required are :- > > > >1. Database Name > >2. Dbspace Name > > > >Thanx in advance. > > > >Informix Dynamic Server Version 7.30UC3. > > > > > >