Chapter 4 Building Physical Diagrams

Setting standard check parameters for objects in a data model

Standard parameters indicate common data constraints. The following table lists standard parameters:

Parameter Description
Minimum Lowest acceptable numeric value
Maximum Highest acceptable numeric value
Default Value selected from a list of default values or typed in the listbox. The list of values is defined in the Script\Keywords\ReservedDefault entry of the DBMS definition file
Format Data format (for example, 9999.99)
Unit Standard measure
Lowercase Forces all alphabetical characters to lowercase
Uppercase Forces all alphabetical characters to uppercase
Cannot Modify Protects from changes, results in a non-modifiable column/entity attribute in the table when generated in the database
List of Values Authorized values
Label String that identifies an authorized value in the list

For more information on defaults, see Defaults (PDM).

Steps To set standard parameters:

  1. Open the property sheet of a domain or column/entity attribute and click the Standard Checks tab.
  2. Enter the appropriate standard parameters, and then click OK.

See also Managing quotation marks around values (PDM).

 

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