What are the differences between No_Transaction and Local_Transaction
Why we are using No_Transactions for General insert,update and delete .
Why we are using Local_Transaction for Batach insert,update and Delete.
if i will use oppositely what happen ???
Please tell me one stupid company has asked this question
No_TX – Auto Commit
LOCAL_TX – Explicit Commit
–Shaik
general Insert/ update / delete → we can use either Local ( explicit commit) or No_transaction ( auto commit)
batch insert/ update /delete → we have to go with local transaction only, if not the tables will not be listed. More info read → 6.5 JDBC adapter user guide under documentation\Adapters_and_eStandards\JDBC_6-5