%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.