‎2013 Jul 11 8:49 AM
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
‎2013 Jul 11 10:49 AM
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
‎2013 Jul 11 10:49 AM
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
‎2013 Jul 11 11:33 AM
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
‎2013 Jul 11 1:33 PM
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