The mpi_strset table is used as a placeholder for unique string sets used within an algorithm function.

Expanded name
String Set
Table category
Algorithm configuration
Provides a placeholder for unique sets of strings to be used within an algorithm function.
Not applicable.
Table 1. mpi_strset 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)
strcode Defined code from mpi_strhead
strval Defined string mapping value

mpi_strset SQL:

CREATE TABLE mpi_strset
caudrecno	bigint		NOT NULL,
maudrecno	bigint		NOT NULL,
recstat		nchar(1)	NOT NULL,
strcode		nvarchar(40)	NOT NULL,
strval		nvarchar(255)	NOT NULL
CREATE UNIQUE INDEX  mpi_strset1 ON mpi_strset (strcode, strval)