RE: Sql Question
Edward
Try the SQL:
SELECT
DBINFO('DBSPACE', HEX(partnum)) DbSpace,
partnum,
tabname,
nrows,
rowsize
FROM systables
WHERE tabid > 99
It gives you everything you need.
HTH
Sujit Pal
----------
From: Edward Bidinotto[SMTP:edbid@cobe.com]
Sent: Monday, October 27, 1997 7:23 AM
To: informix-list@rmy.emory.edu
Subject: Sql Question
How can I grab the nrows and the rowsize of the tables on top of
the information I am currently pulling in.
I want to get the dbspace the table resides in, the part number, the
name of the table, the number of rows and the rowsize.
I've tried some combinations but I'm struggling with a simple join when
I
attempt to pull in systable info..
Any help would be appreciated.
select
name Dbspace,
ti_partnum,
tabname Table
from
systabinfo, systabnames, outer sysdbspaces
where
systabinfo.ti_partnum = systabnames.partnum
and sysdbspaces.dbsnum = trunc(ti_partnum/1048576)
and dbsname = "testdb"
~
~