question about dead lock
I have two programs : zpztest03,zpztest04.
if we run them at the same time, they can run successfully.
but i just think it meets the deadlock condition.
if we change zpztest04 to zpztest05, we just add a line 'commit work' . the program zpztest05 will be dead. why ????
*********zpztest03************** Report ZPZTEST03. tables: SFLIGHT. DATA: SFLIGHT_WA TYPE SFLIGHT, SBOOK_WA TYPE SBOOK. do 100000 times. UPDATE SFLIGHT SET SEATSOCC = SEATSOCC + 1 WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. UPDATE SBOOK SET smoker = '' WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. enddo.
******zpztest04**************** Report ZPZTEST04. tables: SFLIGHT. DATA: SFLIGHT_WA TYPE SFLIGHT, SBOOK_WA TYPE SBOOK. do 100000 times. *commit work. UPDATE SBOOK SET smoker = '' WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. UPDATE SFLIGHT SET SEATSOCC = SEATSOCC + 1 WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. enddo.
**zpztest05**** Report ZPZTEST06. tables: SFLIGHT. DATA: SFLIGHT_WA TYPE SFLIGHT, SBOOK_WA TYPE SBOOK. do 100000 times. commit work. UPDATE SBOOK SET smoker = '' WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. UPDATE SFLIGHT SET SEATSOCC = SEATSOCC + 1 WHERE CARRID = 'LH ' AND CONNID = '0400' AND FLDATE = '19950228'. enddo.