mpi_cvwfunc

The mpi_cvwfunc table contains composite view definitions.

Expanded name
Composite View Function
Table category
Base configuration
Purpose
This table lists the available composite functions that can be configured in InfoSphere® MDM Workbench.
Cross-reference
Not applicable.
Table 1. mpi_cvwfunc 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)
cvwfunccode The function code referenced in mpi_cvwhead.
cvwfuncname The name of the composite function.

mpi_cvwfunc SQL:

CREATE TABLE mpi_cvwfunc
(
caudrecno    bigint		NOT NULL,
maudrecno    bigint		NOT NULL,
recstat      nchar(1)		NOT NULL,
cvwfunccode  nvarchar(12)	NOT NULL,
cvwfuncname  nvarchar(40)	NOT NULL
)