Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to use Enqueue and Dequeue for a local report?

0 Likes
2,522

Hello,

I'm familiar with lock objects, but as far as i understand they are mostly used for table fields. How can i create a simple lock/unlock for a local report? I want just one user to be able to run a report via it's transaction at a time. If a second user tries to run the report while the first user is running it, i want to throw an error message. How can i manage this?

Hello,

I'm familiar with lock objects, but as far as i understand they are mostly used for table fields. How can i create a simple lock/unlock for a local report? I want just one user to be able to run a report via it's transaction at a time. If a second user tries to run the report while the first user is running it, i want to throw an error message. How can i manage this?

3 REPLIES 3
Read only

maheshpalavalli
Active Contributor
Read only

0 Likes
1,919

It's a very old answer, but one member mentioned using of the lock object 'ENQUEUE_ES_PROG'

Read only

Sandra_Rossi
Active Contributor
1,919

Yes, as you say, "they are mostly used for table fields". The word "mostly" is important, because technically speaking the locking is completely independent from database tables. It can be a DDIC structure. The tables are often used because it's more convenient, instead of creating a specific DDIC structure. You may create your own DDIC structure and that's it. Or even use an existing one like TRDIR for instance.