database list under dbspace
Hello All, How can I select all database name under any dbspace thru SQL? I'm not getting any join conditions between sysdbspaces and sysdatabases. please suggest. Thanks Amit ------------------------------ AMIT PATEL ------------------------------ #Informix
Hello Amit, try this: select name[1,30], dbinfo("DBSPACE",partnum)::char(30) as dbspace from sysdatabases; Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------
Amit:
select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1';name art
dbspace datadbs_1
name forums
dbspace datadbs_1
name nologging
dbspace datadbs_1
name logged
dbspace datadbs_1
name pinn_db
dbspace datadbs_1
name antonin
dbspace datadbs_1
name sqlbenchmark
dbspace datadbs_1
7 row(s) retrieved.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------