Question
· Oct 17, 2022

Can you implement transaction processing on linked tables?

Hi,

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.

Neil

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