mpi_strfreq

The mpi_strfreq table is used to limit the number of times a specific string value is bucketed.

Expanded name
Frequency String Values
Table category
Algorithm configuration
Purpose
Defines a frequency limitation on the number of times the same string value is bucketed.
Cross-reference
This table is a child table of mpi_strhead.
Table 1. mpi_strfreq 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 String value
freqval Frequency value

mpi_strfreq SQL:

CREATE TABLE mpi_strfreq
(
caudrecno  bigint		NOT NULL,
maudrecno  bigint		NOT NULL,
recstat    nchar(1)      	NOT NULL,
strcode    nvarchar(40)  	NOT NULL,
strval     nvarchar(255)	NOT NULL,
freqval    int			NOT NULL
)
CREATE UNIQUE INDEX mpi_strfreq1 ON mpi_strfreq (strcode, strval)