How a COMMIT logic can be coded After loading 1000 records

anil_jdh · New User Joined: 05 Apr 2006 Posts: 4

A COBOL-DB2 program is reading a flat file and loading the data from that file to a DB2 table. After loading 1000 records how a COMMIT logic can be coded.

William Thompson · Posted: Tue Apr 17, 2007 10:13 pm

For starters, try looking in the manual under COMMIT.

prasadvrk · Posted: Wed Apr 18, 2007 4:31 pm

You can declare a counter variable, go on incrementing that after each updation and commit when it reaches 1000. But in case of abend you will still not be able to get the record for which the program abended so always implement the restart logic.

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

pass commit count through PARM parameter. keep count in the COBOL program. once the count in program exceeds the PARM count, COMMIT all the data.

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

But this may create problems if the job abends in between. You need to restart the loading from the record which is next to the record which was last committed. This may not be possible in this case, since the input is from a flat file and you cannot direcly identify the records that were committed.

In my opinion, it is better not to have any commit logic in these scenarios.