Hi All,
I seem to be having a little problem that I just can't get my head round.
I have a program (dataload.p) that creates or updates loads of records in my Progress database. If I run the program from the character editor the data loads OK with no more than seven records being locked at any one time.
If I run the same program (dataload.p) from a scheduler that we have it also runs OK with only six or seven records being locked at any one time.
If I then run the update program (dataload.p) from a different program (nightly.p) that runs from the scheduler I get a Lock Table Overflow as it seems that dataload.p doesn't release any locks.
The scheduler and nightly.p call the program in the same way (run value(dataload.p)) but it seems that each program handles the record locking differently. How is this.
I have tryed to add release statements into the code to release the exclusively locked records when it has finished with then but no joy.
If anyone wants any code examples then let me know and I will forward some on.
Database/Scheduler and code all running on IBM AIX, Progress v8.3b.
Thanks,
James.
I seem to be having a little problem that I just can't get my head round.
I have a program (dataload.p) that creates or updates loads of records in my Progress database. If I run the program from the character editor the data loads OK with no more than seven records being locked at any one time.
If I run the same program (dataload.p) from a scheduler that we have it also runs OK with only six or seven records being locked at any one time.
If I then run the update program (dataload.p) from a different program (nightly.p) that runs from the scheduler I get a Lock Table Overflow as it seems that dataload.p doesn't release any locks.
The scheduler and nightly.p call the program in the same way (run value(dataload.p)) but it seems that each program handles the record locking differently. How is this.
I have tryed to add release statements into the code to release the exclusively locked records when it has finished with then but no joy.
If anyone wants any code examples then let me know and I will forward some on.
Database/Scheduler and code all running on IBM AIX, Progress v8.3b.
Thanks,
James.