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

Expanded name
System Properties
Table category
Base configuration
This table is designed to enable system-wide configuration values to be read from the database.
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)