Avoid create two record with first key equal simultaneously.

[Former Member]

Hi, the problem is:

I've done a program that register in a custom table that have more than one key field, i want avoid that this program (used by more dependents simultaneously) register more than one record with the first key field equal. How? I don't think that the ENQUEUE DEQUEUE statement is the solution.

Thanks for the answers.

[Former Member]

Hi, the problem is:

I've done a program that register in a custom table that have more than one key field, i want avoid that this program (used by more dependents simultaneously) register more than one record with the first key field equal. How? I don't think that the ENQUEUE DEQUEUE statement is the solution.

Thanks for the answers.

[RichHeilman]

Sure you can, just create a lock object via SE11, enter all of the keys fields in the lock object. Then when calling the ENQUEUE funciton module, only pass the fields of the key that you wish to lock.

Regards,

Rich Heilman

[Former Member]

And the DEQUEUE statement is necessary to put in program?

[RichHeilman]

I would suggest it. Its always a good idea to release the lock explicitly.

Regards,

Rich Heilman