DF_INDEX_UNIQUE¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
An index on a column that is unique is considered so if it does not have two equal values in that column in two different rows. This attribute is used to find out whether or not the specified index is unique. If it is, this attribute will return “U” indicating that it is indeed unique. This is important to note because when getting the value of this attribute, a string variable must be used. Since this is a ReadOnly attribute, setting an idex to unique cannot be done with this attribute.
Syntax
Get_Attribute DF_INDEX_UNIQUE of {FileNumber} {IndexNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file |
FieldNumber |
Number of the index |
variable |
String indicating if unique |
Example
Open Customer
String sIndexUnique
Get_Attribute DF_INDEX_UNIQUE of Customer.File_Number 1 to sIndexUnique