Physical Option Syntax

If physical options are supported for an object, they are stored in the Options entry beneath the object in the Script/Object category of the DBMS resource file.

For more information, see Common object items. Default values are stored in the DefOptions entry.

During generation, the options selected in the model for each object are stored as a SQL string in the %OPTIONS% variable, which must appear at the end of the Create statement of the object, and cannot be followed by anything else. The following example uses the correct syntax:

create table
[%OPTIONS%]

During reverse engineering by script, the section of the SQL query determined as being the physical options is stored in %OPTIONS%, and will then be parsed when required by an object property sheet.

During live database reverse engineering, the SqlOptsQuery SQL statement is executed to retrieve the physical options which is stored in %OPTIONS% to be parsed when required by an object property sheet.

You can use PowerDesigner variables (see PDM Variables) to set physical options for an object. For example, in Oracle, you can set the following variable for a cluster to make the cluster take the same name as the table.

Cluster %TABLE%

• 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:
• Physical Options Without Names
  A line in an option entry must have a name in order to be identified by PowerDesigner. If a physical option does not have any name, you must add a name between angled brackets <> before the option.
• Defining a Default Value for a Physical Option
  A physical option can have a default value specified by the Default= x keyword, which is placed after the option name or after the %d or %s value, and separated by a colon.
• Defining a List of Values for a Physical Option
  When you use the %d and %s variables, a physical option value can correspond to a list of possible options specified by the list= x | y keyword, which is placed after the option name or after the %d or %s value, and separated by a colon. Possible values are separated by the | character.
• Defining a Physical Option for a Tablespace or a Storage
  A physical option can use the code of a tablespace or a storage. The Category=tablespace and category=storage options build lists of all the tablespace or storage codes defined in the model.
• Composite Physical Option Syntax
  A composite physical option is a physical option that includes other dependent options. These options are selected together in the right pane of the physical options tab.
• Repeating Options Several Times
  Certain databases repeat a block of options, grouped in a composite option, several times. In this case, the composite definition contains the multiple multiple: