%MDUCHGV

Checks the change tables against the target tables to ensure that the updates do not introduce any integrity problems.
Used by: User synchronization

Syntax

%MDUCHGV (TARGET=libref, CHANGE=libref, <TEMP=libref>, ERRORSDS=name);

Required Argument

TARGET
specifies the location of the target canonical tables. This is typically the same libref that you specify in the %MDUEXTR macro.

Optional Arguments

CHANGE
specifies the location of the change tables (that were populated by the %MDUCMP macro).
TEMP
specifies the location for temporary tables (the default is Work).
ERRORSDS
identifies a data set that contains information about any integrity problems. This data set has these columns:
errcode specifies a numeric code for a particular error.
errmsg describes a particular error.
tablename specifies the name of the canonical table from which a particular error item should be excepted if the ERRORSDS data set is fed into the %MDUCMP macro as the exception data set.
filter specifies a SAS WHERE clause that is used to remove all objects related to a particular error from the change tables.
Keyid specifies the keyid value of the offending object.
Name specifies the Name value of the object, if the offending object is a Person or IdentityGroup.
userid specifies the userid value of the object, if the offending object is a Login.
authDomKeyId specifies the keyid value of an authentication domain when duplicate userid values are found in an authentication domain.
If any errors are detected, this macro sets the DUCHGV_ERRORS column to a nonzero value and creates the ERRORSDS data set, which lists the errors that were found.