User Import Macros

%MDUCHGV

Checks the change tables against the target tables to ensure that the updates do not introduce any integrity problems.

Used in:	User Synchronization
Depicted in:	Periodic Synchronization

Syntax

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

TARGET

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

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 non-zero value and creates the ERRORSDS data set, which lists the errors that were found.

Top of Page