partnum not updated in systables ???
Below is the output of a create table statement and subsequent selects on the
partnum field from systables and sysmaster:systabnames. I want to use the
partnum to identify the dbspace the table is in. It works if I query from
systabnames, but the partnum field does not appear to be updated in the
systables table, even after an update statistics. What's the deal here???
------------------------------
Database selected.
drop table testtable1;Table dropped.
create table testtable1
(
column1 decimal(16,0) not null
)
fragment by round robin in account1 , account2
extent size 16 next size 16 lock mode page;Table created.
select tabname, partnum from systables
where tabname='testtable1';
tabname partnum
testtable1 0
1 row(s) retrieved.
select tabname, partnum
from sysmaster:systabnames
where tabname='testtable1';
tabname partnum
testtable1 13631545
testtable1 14680079
2 row(s) retrieved.
disconnect current
Disconnected.
-----------------------------------------------------------------------------
Glenn Travis gtravis@richmond.infi.net
DBA (Ingres/Oracle/Sybase/Informix) gtravis@aol.com
Circuit City Stores, Inc. gtravis@ccity.com
Richmond, VA USA http://www.infi.net/~gtravis