Descriptions in the following parameter table are specific to Relational indexes.
Parameter | Description |
---|
Desttable | The destination table for relational indexing information. desttable stores detail information about the master table. |
destcolumn | Specifies the multi-valued column in the destination table that stores the list of related keys from the master table. |
Sortmode | Specifies the order in which the indexed data is stored. sortmode parameters are: Value | Sort order | Description |
---|
1 | TOP | Put the most recently indexed data at the top (beginning) of the index (reverse chronological order). | 2 | BOT | Put the most recently indexed data at the bottom (end) of the index (chronological order). | 3 | AL | Put the indexed data into alphabetical order (ascending, left justified). | 4 | AR | Put the indexed data into numerical order lowest to highest (ascending, right justified). | 5 | DL | Put the indexed data into reverse alphabetical order (descending, left justified). | 6 | DR | Put the indexed data into reverse numerical order, highest to lowest (descending, right justified). |
|