Re: partnum not updated in systables ???

Glenn, The deal is when you have a fragmented table we don't put a partnum in systables for the database. We can't because there is more then 1 partnumber that is valid for that table. If you want those partnumbers I would either look in sysmasters like you are, or you can check sysfragments table in the database where you created the table. Jacques 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??? > -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************