PLLOCSTATIC

This table contains information about the static assignment of a layout to a user. Each PAGELAYOUT entry can have at most one entry in this table.

Column Descriptions:

NameTypeDescription
PLLOCSTATIC_IDBIGINT NOT NULLPrimary key to the table.
PAGELAYOUT_IDBIGINT NOT NULLThe unique ID of the corresponding page layout.
OWNER_IDBIGINT NOT NULLThe owner or user of the layout.
LOCATIONNAMEVARCHAR (256) NOT NULLThe name of the static location.
ISDEFAULTSMALLINT NOT NULL DEFAULT 0This flag indicates whether the location is default for the user. 0 - Not default 1- Default
SEQUENCEDOUBLE NOT NULL DEFAULT 0.0The sequence of the static assignment for an ownerID.
UP_LOCATIONNAMEVARCHAR (256)The equivalent value of the LOCATIONNAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based search queries issued on the table.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
P_0033PLLOCSTATIC_IDPrimary Key
I0001523PAGELAYOUT_IDUnique Index
IPF00036UP_LOCATIONNAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3771PAGELAYOUT_IDPAGELAYOUTPAGELAYOUT_IDCascade