Defining physical options specified by a value

Chapter 3 DBMS Resource File Reference

Defining physical options specified by a value

Option items contain text that is used to display the option on the Physical Options tabs. Entries may contain %d or %s variables to let the user specify a value. For example:

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

the %d variable - requires a numeric value
%s variable - requires a string value

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

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

Example

With max_rows_per_page is a physical option for Sybase ASE 11.x,which limits the number of rows per data page. The syntax is as follows:

with max_row_per_page = x

The with max_rows_per_page option is shown on the Options tabs with a default value of zero (0):

This option is defined in the DBMS definition file 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.