Chapter 6 Managing Models


Using a conversion table

Conversion tables provide a way to define a correspondence between the name and the code of an object or the code and the name of an object.

Conversion tables are stored into separate CSV (Comma-Separated Values) files and are shared by all models.

PowerDesigner provides CSV file samples stored in the Resource Files\Conversion tables folder of the PowerDesigner installation directory. You can also store the conversion tables you create in that directory.

Conversion tables are not case sensitive. You can indifferently use lower-or-uppercases in tables.

A conversion table encompasses a Name column and a Code column. Depending on the conversion type you use, a name or a code is returned during the generation. However, if several different names have the same code for example, only the first found name is returned.

The following example illustrates a Name To Code conversion where two different names (Customer and Client) have the same code (CUST):


A selected conversion table will be operational only if you simultaneously invoke it using the Convert_name or Convert_code macros in the Conversion script edit box.

For more information on the Convert_name or Convert_code macros, see section Using a conversion script.

Steps To use a conversion table:

  1. Select a conversion table from the Conversion table list located in the lower part of the Name To Code or Code to Name pages.

 


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