The mpi_dvdxcmp table defines the associations between comparison functions and standardization functions.

Expanded name
Derived Data Comparison-to-Standardization Definitions
Table category
Algorithm configuration
This table provides the linkage between a comparison function and a standardization function through the stdrole and cmprole fields.
This table references the mpi_dvdhead table through dvdcode, the mpi_cmpspec table through cmprole and the mpi_dvdxstd table through stdrole.
Table 1. mpi_dvdxcmp 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)
dvdcode Derived data code value
dvdseqno Derived data sequence number
stdrole Standardization role number
cmprole Comparison role number
cmprolelabel Comparison role name
rsfilter Record status on which to filter; any combination of the following statuses– ‘A'ctive, ‘I'nactive, ‘D'eleted, ‘S'hadow (comma-delimited)
dvdargs Derived data arguments passed to the library function
dvddesc Optional derived data bucket instance description
minwgtfreq Defines the minimum count listed in the mpi_strfreq table generated by the mpxfreq utility. If minwgtfreq is 10, only values that occur 10 or more times are listed in the table.

mpi_dvdxcmp SQL:

CREATE TABLE mpi_dvdxcmp
caudrecno    bigint		NOT NULL,
maudrecno    bigint		NOT NULL,
recstat      nchar(1)		NOT NULL,
dvdcode      nvarchar(12)	NOT NULL,
dvdseqno     smallint		NOT NULL,
stdrole      smallint		NOT NULL,
cmprole      smallint		NOT NULL,
cmprolelabel nvarchar(32)	NOT NULL,
rsfilter     nvarchar(8)	NOT NULL,
minwgtfreq   int		NOT NULL,
dvdargs      nvarchar(255)	NULL,
dvddesc      nvarchar(255)	NULL 
CREATE UNIQUE INDEX mpi_dvdxcmp1 ON mpi_dvdxcmp (dvdcode,dvdseqno)