Defining physical options specified by a value

Chapter 3 DBMS Reference Guide

Defining physical options specified by a value

Option entries contain text that is analyzed and used to fill the left pane of the physical options tab of an object. Each line in an Option entry creates a line in the left pane of the physical options tab. The user can click the buttons between the panes of the physical options tab to select these lines.

The lines may or may not contain %d or %s variables to let the user specify a value. Example:

with max_rows_per_page=%d
on %s: category=storage

When you select an option with a %d or %s value appearing in the right pane, an edit field appears at the bottom of the Physical Options box. It is used when the physical option requires a value. The possible variables are:

Variable	Description
%d	Numeric value follows the physical option. You should type a numeric value in the edit field
%s	String follows the physical option. You should type a string in the edit field

Each selected option creates a line in the right pane. If the selection contains a %d variable, a number value can be entered. If the selection contains a %s variable, a text is entered. If the selection contains neither a %d nor %s variable, no value is entered.

Variables between % signs (%--%) are not allowed inside physical options.

You can specify a constraint on any line containing a variable, such as list of values, default values, the value must be a storage or a tablespace, some lines can be grouped. These constraints are introduced by a colon directly following the physical option and separated by commas (see next section).

Example

The Options tab in a table property sheet is shown below.

When the option with max_rows_per_page is selected, the Value box appears at the bottom of the page, next to the Equals button. The default is zero (0).

With max_rows_per_page is an index physical option for Sybase AS Enterprise 11.x. This option limits the number of rows per data page. The syntax is the following:

with max_row_per_page = x

where x is the number of rows specified by the user.

In Sybase Adaptive Server Enterprise, this option can be defined for the index object as follows:

with max_rows_per_page=%d
on %s : category=storage

The %d and %s variables must be in the last position and they must not be followed by other options.