How to define a physical option corresponding to a tablespace or a storage

Chapter 3 DBMS Reference Guide

How to define a physical option corresponding to a tablespace or a storage

A physical option can use the code of a tablespace or a storage: category=tablespace or category=storage builds a list with all the tablespace or storage codes defined in the List of Tablespaces or the List of Storages.

Example

The on segmentname index option specifies that the index is created on the named segment. A Sybase segment corresponds to a PowerDesigner storage. The syntax is:

on segmentname

In Sybase Adaptive Server Enterprise 11, this default value for the index object is defined in option items as follows:

on %s: category=storage

You can select the correct storage from a dropdown list box in the physical options tab.