IM Relationship Resolution Information Center, Version 4.2

DQM function 410: Advanced value lookup

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.

Parameters

SQL Statement
The SQL Statement.
For example,"SELECT FLD3 FROM TBL WHERE FLD1 = @ AND FLD2 = '@'"
Make sure string fields are single-quoted.
Default Value
Default value to store in the UMF tag if the SQL statement does not return a value.
SQL WHERE Clause Value n
This parameter and all subsequent parameters are XPath locations used as the where clause tags.

Exception codes

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


Feedback

Last updated: 2009