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 

See Also

Index Keywords