Problem with updating database

[Former Member]

Hello Friends,

I have a issue with updating the database.Below is the statment by which i am modifying the database.

MODIFY ZSRM_DET_ALRTS FROM TABLE FP_I_MOD_TABLE .

The isssue is when i am running the program the data is getting modified correctly. In production there is a job scheduled to run the program . I see that in production the data is not getting properly updated in this table.From the past 5 to 6 months the issue has increased.

Currently the total no of records in the table ZSRM_DET_ALRTS is 530. Below is the technical description os the table

Data class-APPL1

Size Catagory - 1.

What can be going wrong . I tried running the program in production but it is working fine there and the table is getting updated.

Pls Help.

Rohit

[Former Member]

Hi Rohit,

Use FM DB_COMMIT after insert.

This will definitely help you.

Kindly set to resolved if it helps you.

Regards

Abhii

[Former Member]

Thanks Abhi,

I am already using commit work statement after that.