Skip to Content
0
Former Member
Sep 27, 2012 at 09:49 AM

COMMIT on Custom Database Table

897 Views

Hi All,

I am developing a custom SE38 report with SELECTION-SCREEN .

This Program should delete the data from a custom DB Table.

That DB Table is having huge amount of data (250 Milins) around 2 years of data.

Requirement is I need to make sure that at any point of time, DB table should have the only 7 days of data from Today.

So I am just deleting the data by writing the below query.

1) CALL FUNCTION 'ENQUEUE_E_TABLE' ( To lock the DB Table)

2) DELETE FROM <<Custom DB Table>> WHERE <<Condition>>

3) CALL FUNCTION 'DEQUEUE_E_TABLE' (To Unlock the DB Table)

The issue is that BASIS team claimed that as you have not mentioned any COMMIT statement, our DB Logs are filled up beyond the limit and system crashed.

Can you please advise me, Do I need to write any COMMIT or any Explicit COMMIT happens here.