MASSOC

This table holds all of the possible semantic specifiers that can be used when associating CatalogObjects.

Column Descriptions:

NameTypeDescription
MASSOC_IDCHAR (32) NOT NULLThe Identifier of the semantic specifier. For example, the semantic specifier may be "REQUIRED", "NONE", "TEMP", or "COMES WITH". Other types of specifier can be added.
DESCRIPTIONVARCHAR (254)A description of the semantic specifier.
OIDVARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MASSOC_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_429MASSOC_IDMASSOCCECEMASSOC_IDCascade
F_433MASSOC_IDMASSOCGPGPMASSOC_IDCascade