IM Relationship Resolution Information Center, Version 4.2

DQM function 190: Value lookup

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.

Parameters

Table Name to Search
Configured lookup table name to locate the value in.
Value used for Key Lookup
Optional composite key lookup value.
UMF ID Tag
Optional surrogate key UMF tag value
Tag Name for New Value n
This and all subsequent Tag Name for New Value parameters supply the function with the UMF tag names to add for the retrieved field values. If not supplied, the DQM rule will use the pre-configured lookup table field names.

Exception codes

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 Setup > UMF > Lookup 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


Feedback

Last updated: 2009