topic Re: Open Dataset, Update in Update Task and DB_COMMIT in Application Development and Automation Discussions

Open Dataset, Update in Update Task and DB_COMMIT

dean_hinson2 — Mon, 11 Aug 2025 17:59:56 GMT

Hello,

To increase the performance of a scan and update, I switched to the OPEN DATASET and FETCH with Package Size.

The update happens in an Update Task and then I use FM DB_COMMIT. However, I find the updates are not happening. After debugging, I find that the updates must not in done in Update Task.

I did some googling and I could not find any answers on why? Does anyone have a clue?

Regards, Dean.

Re: Open Dataset, Update in Update Task and DB_COMMIT

Sandra_Rossi — Tue, 12 Aug 2025 07:39:58 GMT

Typo: it's not OPEN DATASET, it's OPEN CURSOR.

Re: Open Dataset, Update in Update Task and DB_COMMIT

Sandra_Rossi — Tue, 12 Aug 2025 12:32:00 GMT

So, you are updating the table via an update function module that you call with CALL FUNCTION '...' IN UPDATE TASK.

You must trigger the update task via COMMIT WORK.

NB: the update task is not triggered by using CALL FUNCTION 'DB_COMMIT' (i.e. executes a database commit) which is only sending a commit instruction to the database.

Read the ABAP Documentation which explains that COMMIT WORK does many things, the 3rd step being the update task, the 5th step being the database commit (https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abapcommit.htm).

Re: Open Dataset, Update in Update Task and DB_COMMIT

dean_hinson2 — Tue, 12 Aug 2025 12:01:59 GMT

You are correct. My muli-tasking failed.

Re: Open Dataset, Update in Update Task and DB_COMMIT

dean_hinson2 — Tue, 12 Aug 2025 12:02:19 GMT

Will do.... Thank you.