Error while Updating DB2 table thru Call from Natural

Hi Guys,

Natural Program A calling COBOL-CICS module B which in turns call COBOL-DB2 module C ( Delete all records from the table) always and COBOL-DB2 module D ( INSERT new records to the Table) based on condition being successful.

Issue is with transaction holding back DB2 table while deletion, but in mean time control return back to Natural Program stating successful output or error message, therefore when try to browse the table its on lock because of the Natural transaction holding the table.

Nitin Dwivedi