We have an application where Java Client is calling a COBOL SP. This SP will update the data passed from Java in DB2 tables and will also extract other referenced data for the given input and store it in a session table.
Once the update for 1000 records is done control goes back to Java Client which does the COMMIT and control comes back to the SP again. My question is, will the data in session table be lost when the control comes back to SP, because of COMMIT. We do have an option of ON COMMIT PRESERVE ROWS while creating the session table but that is something which is not advisable in my organization.
If anyone can help me providing an alternate structure or answer to my question, that will ne a great help.