DF_INDEX_STATUS¶
Applies to: ORAFlex
Oracle has an attribute for indexes called “STATUS” which indicates whether or not an index is valid for use. This attribute can only be used to get the value of the “STATUS” property in Oracle. It currently does not support setting the attribute. The two values for this attribute are “VALID” or “UNUSABLE”.
This is a ReadOnly attribute
Syntax
Get_Attribute DF_INDEX_STATUS of {FileNumber} {IndexNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file |
FieldNumber |
Number of the index |
variable |
String indicating validity |
Example
Open Customer
String sIndexStatus
Get_Attribute DF_INDEX_STATUS of Customer.File_Number 1 to sIndexStatus