Kbase P144866: 4GL/ABL: What is the meaning of the word before WHOLE-INDEX tag on the XREF Listing line?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/04/2009 |
|
Status: Unverified
GOAL:
4GL/ABL: What is the meaning of the word before WHOLE-INDEX tag on the XREF Listing line?
GOAL:
What does the string of words between the SEARCH tag and the WHOLE-INDEX tag of an XREF listing tell us?
GOAL:
What information is included in the string of words between the SEARCH tag and the WHOLE-INDEX tag of an XREF listing tell us?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
Progress 9.x
OpenEdge 10.x
FIX:
The string between the SEARCH tag and the WHOLE-INDEX tag of an XREF listing contains the database, table and index names. That is,the name of the database connected, the name of the table being scanned and the name of the index used to perform that table scan.
For example, compiling the following FOR EACH block with the XREF option:
FOR EACH customer NO-LOCK BY NAME.
END.
Generates the following XREF listing:
.\test.p .\test.p 1 COMPILE test.p
.\test.p .\test.p 1 CPINTERNAL ISO8859-1
.\test.p .\test.p 1 CPSTREAM ISO8859-1
.\test.p .\test.p 1 STRING "Customer" 8 NONE UNTRANSLATABLE
.\test.p .\test.p 1 ACCESS sports2000.Customer Name
.\test.p .\test.p 1 SEARCH sports2000.Customer Name WHOLE-INDEX
.\test.p .\test.p 2 STRING "Name" 4 NONE UNTRANSLATABLE
In the above XREF listing, the string between the SEARCH and the WHOLE-INDEX tags is: sports2000.Customer Name. Where:
Sports2000 is the name of the connected database, and
Customer is the name of the table being scanned to resolve the above query, and
Name is the name of the Index used to perform the above mentioned table scan.