Chapter 3 DBMS Resource File Reference

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   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. For example
IndexOption =
<duprow> %s: default= ignore_dup_row ,
list=ignore_dup_row | allow_dup_row

 

Copyright (C) 2008. Sybase Inc. All rights reserved.