Chapter 2 Physical Data Model Basics


PDM properties

The Model property sheet displays the definition of the current model. From this property sheet you can modify the model definition.

A PDM has the following model properties:

Property Description
Name Name for the model
Code Code for the model. This code is generated in database scripts
Comment Descriptive label for the model
File name Location of the model file. This box is empty if the model has never been saved
Author Author of the model. You can insert a name, a space, or nothing.

If you insert a space, the Author field in the title box remains empty.

If you intentionally leave the box empty, the Author field in the title box displays the user name from the Version Info page of the model property sheet
Version Version of the model. You can use this box to display the repository version or a user defined version of the model. This parameter is defined in the display preferences (Title node)
DBMS Current DBMS for the model. You can open the property sheet for the DBMS by clicking the Properties tool at the end of the box
Database Database name for the model. You can define and select databases with new physical properties. If you click the Create tool beside the Database box, a confirmation box asks you to commit object creation, and the database property sheet appears. You can define the properties of the new database and click OK
Default diagram Diagram displayed by default when you open the model

Note   Models for DB2
The Database box does not appear in the models targeted for the DB2 family as these models support multiple databases in a single model. For more information, see section Multiple databases in a model in chapter DBMS-specific Features.

Steps To modify PDM properties:

  1. Select Model→Model Properties.

    or

    Right click the diagram background and select Properties from the contextual menu.

    The model property sheet appears.
  2. Type changes to model properties.
  3. Click OK.

 


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