Skip to Content
Former Member
Oct 21, 2008 at 04:29 PM

Issue in locking Table


Hi All,

I need to update a ZTABLE with UNIQUE serial number while creating shipment and Delivery.

I have used ENQUEUE_E_TABLE to lock the table before updating table in both the ZProgram which will update the serial numbers.

The problem is even though i locked the table , i am facing problem with creation of duplicate number serial numbers while shipment and delivery happens at the same time.We have tested this with multiuser environment.

Since both shipment and delivery updating in UPDATE TASK i coudnt use COMMIT WORK in the programs.

Please let me know if there are any tricks how to lock the table and also for using COMMIT WORK inside UPDATE TASK.

Give some example program for locking tables especialy used in update task.

Thanks and Regards,