Progress
Language Reference
INDEX-INFORMATION Attribute
A character string consisting of a comma-separated list of the index or indexes the query uses at the level of join specified.
Data Type: CHARACTERAccess: ReadableApplies To: Query Object Handle
n
An INTEGER expression that evaluates to the level of join for which you want index information.
If the index or indexes do not have bracketing, the first entry in the list is the CHARACTER string “WHOLE-INDEX,” and the second entry in the list is name of the index.
Before you use INDEX-INFORMATION on a dynamic query, you must prepare the query using the QUERY-PREPARE method.
Before you can use the INDEX-INFORMATION attribute on a static query, you must define the query using the DEFINE QUERY statement’s RCODE-INFORMATION option.
The following example prints out the PREPARE-STRING, analyzes the INDEX-INFORMATION, and prints a list of bracketed and whole-index indexes.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |