DQM function 410 locates a value based on a dynamically created SQL statement.and stores it in the UMF tag value.
The dynamically created SQL statement is generated based on rules and UMF data
If you configure the DQM rule to correct the data, and the value is not found in the database, the Default Value parameter value is stored.
Return Code | Description | Severity* |
-4 | Could not locate the bind value in the UMF. | 3 |
-3 | Mismatched number of bind variables and XPATH bind values. | 3 |
-2 | A SQL error occurred while looking up SQL value. | 3 |
-1 | The record set did not return any rows and default was not applied. | 3 |
1 | The value was retrieved by the SQL statement. | 0 |
2 | The default value was applied. | 1 |