DataUpdate mappings use the DataUpdate node, which lets you update any existing database fields with new information. You cannot delete or insert fields currently existing in a database using this node. To do this, use either a DataDelete node or a DataInsert node respectively.
For each type of DataUpdate mapping listed below, the number of rows that are updated depends on how many rows satisfy the user-specified condition. The condition is usually an operation involving one or more columns in the table. The tool generates the condition as a function of primary keys of the table.
One-to-one mappings are also allowed; in this case, the value that the target column takes is the value of the mapped input element. These insert statements can also be combined to produce a single insert that inserts several columns into the same row, as each insert statement creates a new row.
Click Keep selected mappings to merge the selected items or Remove selected mappings to delete the selected items.
Edit the final WHERE clause of the combined mapping. Each pre-combination mapping already has a WHERE clause.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ar00880_ |