Question
Is it possible to update several different DBs in a single transaction?
If possible, what is the processing result like when an error occurs?
Answer
If the target DBs support transactions, multiple DBs update processes can be set up in a single transaction.
To check if the target DB connectors support transactions, please refer to the [Transaction] section of the relevant DB update process in the Connector Operation Guide on the following manual.
[Connector Operation Guide]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/operation_guide.htm
Also, if an error occurs in a transaction, the update processing to DBs in the transaction will be rolled back.
However, the result of the processing depends on each DB specifications.
Please confirm the result in actual operations.
Comments
0 comments
Article is closed for comments.