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

Index table Using in Multiple Programs Parallely - Lock Issue

rahul_pathak78
Explorer
0 Likes
1,144

Hi Experts,

I am using Import/Export ( FROM DATABASE indx(xy)) in program to sent Internal tables from called report to caller report.

Is there any lock issue if multiple programs are using same logic i.e. Import/Export using INDX at same time

Please note Index key are unique for each program.

Advance thanks.

Regards,

Rahul Pathak

FROM DATABASE indx
1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
830

Hi Rahul,

there should be no lock issues for different keys.

Rahul P wrote:


IPlease note Index key are unique for each program.

But if one program parallely runs two or more times at the same time, you either have to create different keys (add username, plant or sth. else to the key to make it unique again) or prevent this by a lock mechanism.

Regards,

Klaus

3 REPLIES 3
Read only

Former Member
0 Likes
831

Hi Rahul,

there should be no lock issues for different keys.

Rahul P wrote:


IPlease note Index key are unique for each program.

But if one program parallely runs two or more times at the same time, you either have to create different keys (add username, plant or sth. else to the key to make it unique again) or prevent this by a lock mechanism.

Regards,

Klaus

Read only

0 Likes
830

Hi Klaus,

Thanks for your reply .

Can you please provide a brief technical explanation .

I was just worrying when different program export data and try to create entry for this in INDX table then  INDEX table may be lock for one program.

I guess ,I don't have not the good understating of  INDX table mechanism.

Regards,

Rahul Pathak

Read only

0 Likes
830

Hi Rahul,

I can give no technical explanation so fast, but I have a running application using an INDX like table.

This table I use to pass several different texts of user requests from a web application. Unique key is the user request number (for which I have a lock object), so each request can only be opened once. But lots of different requests may be open at the same time, all of them having table access at the same timea and passing data through several classes and methods.

This works without trouble and is facing no issues.

Regards,

Klaus