Java- Mainframe DB connection and sugession
We are currently using IMS DB Connect to connect the IBM mainframe DB (IMS DB) with Java.
Restrictions of this: We can connect to the DB only for inserting the new records
We are looking for a solution, to retrieve a data from IMS DB and process the data and update the data directly to the IMS DB. Please suggest us the right solution to achieve this using java.
My manager gave me few solutions.
1. Use IBM tool DB view- but this also restricts us to view the data but not updating the data directly to the db.
2. Create some web services (SOAP) and try to access this from IMS DB.
Please give solutions/forum/materials, where I can get more details to explore and implement this.
Thanks in Advance