mpi_sysprop

The mpi_sysprop table is used to define system-wide configuration values.

Expanded name
System Properties
Table category
Base configuration
Purpose
This table is designed to enable system-wide configuration values to be read from the database.
Cross-reference
Not applicable.
Table 1. mpi_sysprop Attribute Descriptions
Attribute Description
caudrecno Creation of this particular record, from mpi_audhead
maudrecno Last time the record value was modified, from mpi_audhead
recstat Record status; A(ctive) or I(nactive)
segrecno Segment record identifier
therecno Default record identifier
propname Property name
propval Property value

mpi_sysprop SQL:

CREATE TABLE mpi_sysprop
(
caudrecno  bigint		NOT NULL,
maudrecno  bigint		NOT NULL,
recstat    nchar(1)		NOT NULL,
segrecno   int			NOT NULL,
therecno   bigint		NOT NULL,
propname   nvarchar(40)		NOT NULL,
propval    nvarchar(255)	NULL
)
CREATE UNIQUE INDEX mpi_sysprop1 ON mpi_sysprop (segrecno, therecno, propname)