How to define a list of values for a physical option

Chapter 3 DBMS Reference Guide

How to define 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. The List= keyword is used to specify this list. After the physical option name, or after the %d or %s value, it is necessary to add a colon, then list= x | y co where x , y and z are the possible values. The values are separated by the | ( pipe) character.

Example

The dup_prow option of a Sybase Adaptive Server Enterprise index corresponds to two mutually exclusive options for creating a non-unique, clustered index. This option can be either ignored or allowed.

In Sybase Adaptive Server Enterprise 11:

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

A dropdown list box with the values is displayed below the right pane of the physical options tab.

Use a comma to separate default and list
If Default= and List= are used at the same time, they must be separated by a comma.

Example

If ignore_dup_row is the default value for an index, the syntax used in the DBMS definition file to define this value is the following:

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