Sql Question

Posted in 1997

Edward Bidinotto — Mon, 27 Oct 1997 07:23:08 -0700 — source: Informix-list mailing list archive (1991-1998)

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" ~ ~