IM InfoSphere Identity Insight, Version 8.0

DQM function 160: Maximum length check

DQM function 160 validates the length and truncates the value of the UMF tag.

The function is used to prevent tags with too many characters for their corresponding SQL fields from being inserted into the database.

If the correction procedures are configured and the length of the value exceeds the configured maximum, then the function trims the excess from the value of the UMF tag from right to left. If the correction procedure is not configured to correct an error, the function logs an exception to the configured error log and does not load the invalid value.

If you are using the DQM 160 rule to check a LAST_NAME attribute value length, make sure to run a DQM 255 rule (name standardization) first before running the DQM 160 rule. This will prevent the LAST_NAME length from being increased after the DQM 160 rule (maximum length check) runs, when the other parts are present.

Parameters

Maximum Length
The maximum length allowed for the UMF tag value.

Exception Codes

Exception Code Description Severity*
-1 The value of the UMF tag exceeds the maximum allowed length, but the rule is not configured to perform correction procedures. 3
1 The value of the UMF tag was too long, so the function truncated the value. 0


Feedback

Last updated: 2011