| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DataUpdate : Setting scope and mentioning column names. |
« View previous topic :: View next topic » |
| Author |
Message
|
| Cogito-Ergo-Sum |
 Posted: Mon Jun 06, 2011 10:57 pm Post subject: DataUpdate : Setting scope and mentioning column names. |
 |
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
A DB2 UPDATE statement has a WHERE clause that sets the scope for update. It also has a SET statement that mentions the column and the value to be updated. With DataUpdate node, how do I set the scope and mention the columns to be updated ?
The venerable InfoCenter (6.1) is missing the documentation for DataUpdate node. So, just to understand this node better, I looked in 7.1 documentation. In 7.1, the documentation states the Purpose of DataUpdate node as follows.
| Quote: |
The DataUpdate node is a specialized form of the Database node, and the interaction is restricted to updating one or more rows in a table within the database. You define what is updated by defining mapping statements that use the data from the input message to identify the action required.
|
The italicised text in the quote above is not clear to me. The way I see, what is updated has two parts; first, the WHERE clause that sets the scope of update and second, the SET statement that mentions the columns to be updated. Consider the example in the documentation.
| Quote: |
Consider a scenario in which you have added the details of a new product, a keyboard, to your stock database. Now you have received a message from the Goods In department that indicates that 500 keyboards have been delivered to your premises. You can use the DataUpdate node to change the quantity of keyboards in your database from zero to 500. |
In the above example, it would be trivial to update the number of keyboards throughout the table. A more realistic scenario would be applying limiting conditions (think, WHERE clause) such as WAREHOUSE_ID (that received the keyboards) or KEYBOARD_MODEL (the kind of keyboard received) and so on. I am not able to locate documentation where I could mention such WHERE clauses using the incoming message.
I did read Modifying databases using message mappings - but, it covers database delete; not update. And, even in case of DataDelete, I am able to enter only one $db:delete equated to an incoming message condition. If I want to add more using AND condition in Edit pane, I get an error about an invalid expression.
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
