Re: partnum not updated in systables ???

Supply the version of Informix you are using. I also noticed you did not run an update statistics for table testtable1 right after you created the table. Then select from the systables. This may work anyway supply the version of Informix you are using. ------------------------------------------------------------------------- Cheryl Kendricks Internet: cherylk@spamis.jcdc.doleta.gov OR cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 10 Apr 1996, Glenn Travis wrote: } 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 } } }