Defining a List of Values for a Physical Option

When you use the %d and %s variables, a physical option value can correspond to a list of possible options specified by the list= x | y keyword, which is placed after the option name or after the %d or %s value, and separated by a colon. Possible values are separated by the | character.

For example, the dup_prow option of a Sybase ASE 11 index has two mutually exclusive options for creating a non-unique, clustered index:

IndexOption =
<duprow> %s: list=ignore_dup_row | allow_dup_row

A list with the values is displayed on the Physical Options tabs.

Note: If Default= and List= are used at the same time, they must be separated by a comma. For example IndexOption = <duprow> %s: default= ignore_dup_row, list=ignore_dup_row | allow_dup_row