Index_Segment_Field
The field number of the index segment column.
Supported By
- SQL Drivers (SQL Server, DB2, and ODBC)
Value
0 .. Number of columns in the table
Associated Attribute
- DF_INDEX_SEGMENT_FIELD (Integer)
Remarks
The number of the column in the current segment. There must be an Index_Segment_Field line for every segment in the index.
For example, if we want to define index 4 as having three segments where segment 1 is column 5, segment 2 is column 3, and segment 3 is column 2, this would look like:
Index_Number 4
Index_Number_Segments 3
Index_Segment_Field 5
Index_Segment_Field 3
Index_Segment_Field 2