Hi guys,
I have this assignment that required me to do the followings,
I would like to know if there exist any mechanism or method to prevent dirty read on the Data Area before another process committed the update? Or if there exist any method to solve the synchronization issue?
My current approach is to use JTOpen and have 2 connections: (1) AS400 (2) AS400JDBC
(1) By using AS400 Connection, i will read the decimal value
(2) By using AS400 JDBC Connection, i will use that value and run an insert statement
(3) If insert is committed successfully, by using AS400 Connection, i will then update the value by +1
But this din solve the synchronization issue, do it?
Do correct me if i am wrong.
Thanks for your helps.
I have this assignment that required me to do the followings,
- To retrieve a Next Transaction ID from Data Area (Decimal)
- To use that ID in a SQL Insert Statement on a specific table on the same system
- For a successful insert (committed), the value of Transaction ID should be updated
I would like to know if there exist any mechanism or method to prevent dirty read on the Data Area before another process committed the update? Or if there exist any method to solve the synchronization issue?
My current approach is to use JTOpen and have 2 connections: (1) AS400 (2) AS400JDBC
(1) By using AS400 Connection, i will read the decimal value
(2) By using AS400 JDBC Connection, i will use that value and run an insert statement
(3) If insert is committed successfully, by using AS400 Connection, i will then update the value by +1
But this din solve the synchronization issue, do it?
Do correct me if i am wrong.
Thanks for your helps.
Comment