| update errors overwrite [message #269132] |
Thu, 20 September 2007 15:28  |
grgeckorock
Messages: 1
Registered: September 2007
|
Junior Member |
|
|
We have streams set up bidirectionally such that all transactions in the custom schema are stream'd to an identical schema in a separate instance. There are no triggers, and the architects have defined specific transactions to take place in one instance or the other such that we should not see the same records being updated in both instances. However, this is a restriction built only into the application, so conflicts may occur.
In the event of a conflict, we want to first examine the conflict before a fix is applied.
Is it possible to create a procedure that will automatically apply an LCR, overwriting the conflict, that is neutral regarding the table? We have over a thousand tables and do not want to write handlers for each and every table.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
