Row Level Locking while inserting a record.

[Former Member]

It is a good practice to lock the whole table or do the row level locking while performing any DELETE / UPDATE / MODIFY actions on a database table. Is it necessary to do the same thing while inserting a record via INSERT statement?

One point may arise if two users are inserting same records at a same time....

Well i am little bit confused here bcos if a record doen't exist in a table what is the point of locking it.

Please help me.

[Former Member]

create a lock object using SE11 for that perticular table and include field names in Lock parameters. Then it will generate two FMs one for locking and another for unlocking.

Call the lock FM before updating the table and pass that row key value(For fields which taken in lock parameters for creating lock objects) to the exporting parameters.

Then do the updation.

Reward if useful...................

[Former Member]

Well Poorma, U are quite right about how to make a lock objects and how to use them, but my question is different here. I want to know that whether one should use row level locking while insertion or not.