This table relates catalog groups (or categories) to the catalog entries that are inside them. You can also use this table to dictate the navigational flow from catalog groups to catalog entries. Each relationship is also qualified by a Catalog ID.

Column Descriptions:

CATGROUP_IDBIGINT NOT NULLThe source catalog group of this relationship.
CATALOG_IDBIGINT NOT NULLThe catalog inside of which this relationship is found.
CATENTRY_IDBIGINT NOT NULLThe target catalog entry of this relationship.
RULEVARCHAR (254)Reserved for IBM internal use.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATETIMESTAMPIndicates the last time that this relationship was updated.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000523CATALOG_IDNon-Unique Index
I0000524CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType