METALIB Procedure
IMPACT_LIMIT Statement
Specifies the maximum number of Job or Transformation
objects that can be affected by an update to a table definition.
| See: | Generating an Impact Analysis |
Syntax
IMPACT_LIMIT=n;
Details
The IMPACT_LIMIT statement
is optional. An impact analysis is not performed unless IMPACT_LIMIT
and REPORT are specified.
The recommended usage
is as follows:
-
Specify IMPACT_LIMIT=0 with REPORT to determine what tables have associated Job or Transformation objects.
-
Specify IMPACT_LIMIT=0 with REPORT (TYPE=DETAIL) to identify which type of object is associated: Job or Transformation.
-
Specify IMPACT_LIMIT with an integer that specifies the number of Job or Transformation objects found. Any updates to table definitions will be made.
IMPACT_LIMIT identifies
potential impact only. It does not verify that a Job or Transformation
object was affected, only that it could
be affected.
IMPACT_LIMIT identifies
only the Job or Transformation objects that can be directly affected.
These objects might contain many other objects that could also be
affected down the line by the changes, but those objects are not analyzed.
If you would like to perform a more thorough impact analysis, you
can use SAS Data Integration Studio.