Hi,

Informix online - INFORMIX-SQL Version 5.10.UC2.

How to find which dbspace the Table belongs.

Thanks

Hi there,

Foll is the query
database sysmaster;
select s2.name,s1.tabname,s1.owner from systabnames s1,sysdbspaces s2
where s2.dbsnum=trunc(s1.partnum/1048576)
and s1.owner='ocslinkdev'
order by name,tabname,owner

Regards,

lloyd

Llyod,

sysmaster database is not available on Informix online 5. Please where the tables on sql can be found.

Thanks