OpenEdge - Generating a Compile Listing File
Compile the file using below command
COMPILE <Fully Qualified File Name> LISTING <Full Name of the Listing File>
This will give you a listing file which contains below information
1. Source code with each line numbered
2. Transaction blocks with starting line number
3. Buffers & Frame names used in code block
In a scenario where a transaction scope to be determined, listing file can be used. This is most efficient in determining the point at which a table lock to be released. Even though a table lock is released inside a loop, the database does not release it until the belonging transaction block is completed. Issue in this case is that even though the programmer sees that the lock has been released in code, the program run-time keeps all the record locks till end of transaction block which can cause the -L error. (Lock table over flow).
Compile the source file and find out at which point the lock gets released
No comments:
Post a Comment