Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jacques Renaut — — source: Informix-list mailing list archive (1991-1998)
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> *
********************************************************************
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.