Skip to Content
0
Former Member
Jan 03, 2008 at 12:16 AM

inserting values in a data dictionary table with out losing data

44 Views

Hello All,

I have some issues with updating a table. The program works fine. But problem arrives when two users try to run the program at the same time. I am getting only one update in the table. The other data is getting lost. This happens only when both users try to update at the same time. I am using following statement:

INSERT dbtab FROM TABLE itab.

How I can lock the dbtab while it is being used by one user , so that I do not lose data from second user? Can I create some type of queue so that while one user is writing the data to dbtab, the other user data get queued up and when dbtab is available, this queued data can be written to it.

Thanks for the help in advanced!