Open Dataset, Update in Update Task and DB_COMMIT

[dean_hinson2]

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.

[Sandra_Rossi]

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

[dean_hinson2]

You are correct. My muli-tasking failed.

[Sandra_Rossi]

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).

[dean_hinson2]

Will do.... Thank you.