Modify Statement takes longer time

[Former Member]

Hi ,

I am modifying database from an internal table.

MODIFY data_base FROM TABLE it_table.

It takes long time and gets a dump with time out error. Even The table it_table contains less number of records the program gets stuck in this statement.

Please suggest what should be done.

[Sandeep_Panghal]

try modifying only record and check the time, also check DB locks in DB01 txn.

[Former Member]

Even for single record it is the same.

[Sandeep_Panghal]

then contact your system admin and find out if there are any perf. issues wiith the UPD work process

[kesavadas_thekkillath]

no of records in it_table ???

[Former Member]

Hi,

If you are just trying to modify the existing records means try UPDATE statement.