Adaptive Server version 12.5.0.3 allowed RPCs to create temporary objects for the duration of the remote procedure call. Because of this, proxy tables mapped to RPCs could not participate in transactions, and the work done by the RPC could not be rolled back.
Adaptive Server version 12.5.2 allows proxy tables mapped to RPC to participate in transactions by default, which allows Adaptive Server to maintain data integrity with roll backs.
Start Adaptive Server with trace flag 11228 to revert to the
version 12.5.0.3 behavior. However, if you use the insert..
select syntax with proxy tables and proxy RPCs (for example, insert
proxy_table1 select proxy_RPC),
and the proxy table and proxy RPC both reside on the same remote
server, the insert portion of the query does
not rollback.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
