mpi_strset
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
- Purpose
- Provides a placeholder for unique sets of strings to be used within an algorithm function.
- Cross-reference
- Not applicable.
| 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)