f2s_ora_index_sql_status¶

Applies to: Oracle Driver

Syntax

**There is no set_attribute.  This attribute is read only.**
get_attribute f2s_ora_index_sql_status of {FileNumber} {index} to {variable}

Parameter	Description
FileNumber	Number of the file (filename.File_Number)
index	The number of the index
variable	String variable. The return value with be either “VALID” or “UNUSABLE”

Description

Oracle has an attribute for indexes called “STATUS” which indicates whether or not an index is valid for use. This read only attribute can be used to get the value of the “STATUS” property in Oracle. It currently does not support setting the attribute. The two values returned for this attribute are “VALID” or “UNUSABLE”.

Examples

get_attribute

String sValue

Get_Attribute f2s_ora_index_sql_status of Customer.File_Number 4 to sValue

Showln (SFormat("The status of Customer index 4 is %1",sValue))

Replaces: DF_INDEX_STATUS