Xref specifies the file where the Application Compiler writes
cross-reference information between source files and database
objects.xref. For each object reference, the .xref file contains one
unformatted and blank-separated line containing the following:
1) Procedure name
2) Source filename
3) Line number
4) Reference type
5) Object identifier
-- List of tags the XREF compile option generates:
SEARCH:
Indicates an index bracket or look up will be used. The logical
database name, table name, and index names are listed. When multiple
brackets and indexes are used for the same query, you will see one
search line for each bracket.
SEARCH ... WHOLE-INDEX:
Indicates that a suitable bracket could not be constructed and an
index scan over the entire table will be performed using the index
noted.
SORT-ACCESS:
Indicates that the query result is to be ordered by a particular
column value and no suitable index exists. A sort of the query result
on the noted column value is required.
ACCESS:
Indicates that the specified table and field value is used at this
point in the program.
CREATE:
Indicates that a record is created at this location in the program.
DELETE:
Indicates that a record is deleted at this location in the program.
UPDATE:
Indicates that the specified field value of a table is updated at this
location in the program.
See the COMPILE statement in the Progress Language Reference for more
information on the cross-reference file.
Refer Pro kb id 21100