topic Re: Index table Using in Multiple Programs Parallely - Lock Issue in Application Development and Automation Discussions

Index table Using in Multiple Programs Parallely - Lock Issue

rahul_pathak78 — Thu, 11 Jul 2013 07:49:56 GMT

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

Re: Index table Using in Multiple Programs Parallely - Lock Issue

Former Member — Thu, 11 Jul 2013 09:49:46 GMT

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

Re: Index table Using in Multiple Programs Parallely - Lock Issue

rahul_pathak78 — Thu, 11 Jul 2013 10:33:27 GMT

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

Re: Index table Using in Multiple Programs Parallely - Lock Issue

Former Member — Thu, 11 Jul 2013 12:33:30 GMT

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