Neil Thaiss · Oct 17, 2022

Can you implement transaction processing on linked tables?


I need to do a DELETE and then do some INSERT transactions on a linked table and don't want the DELETE and need to be able to ROLLBACK the DELETE if any of the INSERT transactions fail.
I have tried Object Script transaction processing (TSTART, TCOMMIT and TROLLBACK) and the SQL transaction processing (START TRANSACTION, COMMIT and ROLLBACK), but neither work.
Could I be doing something wrong in the way I am implementing these, or do does transaction processing simply not work for linked table?

Thanks for any advices, in advance.


Product version: IRIS 2021.1
$ZV: IRIS for Windows (x86-64) 2021.1.1 (Build 324U) Thu Feb 24 2022 13:18:53 EST
0 95
Discussion (1)1
Log in or sign up to continue

Unfortunately we're not able to offer transactions across linked tables. For one thing, the remote database may use different transaction semantics. I will request this gets clarified in our documentation, as it's not called out right now as a limitation of linked tables.