Chapter 3 DBMS Reference Guide

How to define a default value for a physical option

A physical option can have a default value. The Default= keyword is used to specify this value. After the physical option name or after the %d or %s value, it is necessary to add a colon default=x , where x is the default value for the target database.

Example

The default value for max_row_per_page is 0. In Sybase Adaptive Server Enterprise 11, this default value for the index object is defined as follows:

max_rows_per_page=%d : default=0

The default value is displayed by default in the Options window.

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