PreviousDTO Programmer's Guide (9.1 revision 1) Next

DtoSegment Object

Show this topic in Library frames

This object represents a segment in an index.

Properties

ColumnName
Gets or setes the column name associated with this segment.
Flags
Gets or sets the segment flags. This is an enumerated value. See Segment Flags for a list of possible values.
Number
Gets or setes the 0-based segment number.

Methods

None

Remarks

One or more of these comprise an index. Only 119 segments are allowed per index. Note that the combined size of all the columns in segments of an index cannot be more then 255 bytes.

Example
' Open dictionary 
Dim dictionary as new DtoDictionary 
Dim result as DtoResult 
result = dictionary.Open("c:\pvsw\demodata") 
' Get Students table 
Dim students_table as DtoTable 
Set students_table = dictionary.GetTable("Student") 
' Obtain indexes collection from students table 
Dim students_idx as DtoIndexes 
Set students_idx = students_table.Indexes 
' Delete all the indexes 
Dim first_idx as DtoIndex 
Set first_idx = students_idx(1) 
' Get DtoSegments collection from first_idx  
Dim my_segments as DtoSegments 
Set my_segments as first_idx.Segments 
' Get first segment and query column name 
Dim first_seg as DtoSegment 
Set first_seg = my_segments(1) 
Dim colname as String 
colname = first_seg.ColumnName 
See Also

DtoSegments Collection
DtoTable Object
DtoIndexes Collection


Chapter contents
Publication contents

Prev topic: DtoSegments Collection
Next topic: Distributed Tuning Objects Enumerations