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