Home | Previous Page | Next Page   System Catalog Tables >

SYSREPOSITORY (XPS)

The sysrepository system catalog table contains data about generalized-key indexes that the sysindexes system catalog table does not provide.

Column Type Explanation
id1 VARCHAR(128) Index from the generalized-key (GK) index
id2 INTEGER Tabid of table with the generalized-key index
type INTEGER Integer code for type of object

In this release, the only value that can appear is 1, indicating a GK index type.
seqid SERIAL Reserved for future use

(This value is not related to syssequences.seqid.)
desc TEXT The CREATE INDEX statement of a GK index
bin BYTE Internal representation of the generalized-key index

The contents of the sysrepository table are useful when a generalized-key index has to be rebuilt during a recovery or if a user wants to see the CREATE statement for a specific generalized-key index.

The desc column contains the CREATE statement for each generalized-key index in the database.

An index on the seqid column allows duplicate values. A composite index on the id1, id2, and type columns requires unique combinations of values.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]