Assignments
The Database agents are designed to either collect data from a database column and assign it to a UDR field, or vice versa. In their configuration they share the Assignment tab, where these mappings are configured. Due to the resemblance this configuration is described here.
| Item | Description | |||||
|---|---|---|---|---|---|---|
Refresh | Updates the table with all the columns or parameters from the selected table or stored procedure (Database forwarding agent, only).
If rows already exist in the table, the refresh operation preserves the configuration for all rows with a corresponding column or parameter name. Thus, if a table has been extended with a new column, the old column configurations are left untouched and the new column appears when Refresh is selected. The value type on each new column that appears in the table is automatically set to UDR Field. Auto assignment: All rows with no value assigned and with a value type of UDR Field will be targeted for auto assignment in the end of the refresh process. If the selected UDR type contains a field whose name matches the column name, the field will be automatically assigned in the Value column. Matching is not case-sensitive and is done after stripping both the column and field names from any characters, except a-z and 0-9. | |||||
Column Name | Displays a list of all columns or stored procedure parameters (Database forwarding agent, only) for the selected table or stored procedure, except the Transaction ID column. | |||||
Column Type | Displays the data type for each column as declared in the database table. If the column does not accept NULL this is displayed as: (NOT NULL).
| |||||
Value Type | Allows the user to select what type of value to be assigned to the column, or vice versa. For further information, see the section below, Value Types. | |||||
Value | The value to be assigned to the column, or vice versa. The technique of selecting a value depends on the selected Value Type.
|
Value Types
The Database agents offer six different types of values that may be assigned to a column, or vice versa. Depending on the agent, not all value types are applicable and will therefore not be available in the list.
...