Chapter 3 DBMS Reference Guide

Syntax for a physical option without a name

A line in an option entry should not contain only a variable. It has to contain a text from the physical option or a name in order to be identified by PowerDesigner. A physical option without a text can not be represented in the PowerDesigner syntax. If a physical option does not have any name, you must add a name between angled brackets <> before the option. This indicator is a word describing the physical option to be entered.

Example

To define segment in Sybase AS Enterprise 11, the proper syntax is the following:

sp_addsegment segmentname, databasename, devicename

segmentname corresponds to the storage code defined in PowerDesigner. databasename corresponds to the model code. These two entries are automatically generated. devicename must be entered by the user, it becomes an option.

In SYSTEM11, this option is defined as follows:

Create = execute sp_addsegment %STORAGE%, %DATABASE%, %OPTIONS%
OPTIONS = <devname> %s

A physical option without name must be followed by the %d or the %s variable.

Copyright (C) 2005. Sybase Inc. All rights reserved.