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
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.
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.