DQM function 190 validates that the value of a UMF tag matches a value in a configured lookup table.
If the value of the UMF tag exists in a configured lookup table, then surrogate key values can be assigned.
For example, DSRC_CODE can be configured with a DQM 190 rule to validate that the incoming <DSRC_CODE> UMF tag value is a configured data source code, and it can retrieve associated DSRC_ID value to be stored for all incoming data pertaining to that DSRC_CODE.
If you configure the DQM rule to correct the data, and the value is not located in the memory table, then the function attempts to locate it in the database. If after this second attempt the value is still not located, then the function adds the value to the database table. 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.
Exception Code | Description | Severity* |
-3 | A database error has occurred. | 3 |
-2 | The lookup table being searched is not properly configured in the Configuration Console | screen.3 |
-1 | The UMF tag value was not located in the table and correction procedures are not configured. | 3 |
1 | The UMF tag value was not located, therefore it was added to the database table. | 1 |
3 | The UMF tag value was located in the database table and added to the processes memory table. | 0 |