Chapter 3 DBMS Reference Guide
Data type translation table showing the mapping from the DBMS definition file data types to the PowerDesigner internal data types. This is used during PDM to CDM generation and with the Change Current DBMS command (use of PowerDesigner internal data types to find a match between two DBMS definition file data types). The following variables are used to qualify the data type:
| Variable | Indicates |
|---|---|
| %n | Length of the data type |
| %s | Size of the data type |
| %p | Precision of the data type |
Using the variables defined to qualify the mapping, PowerDesigner creates an effective interface between its native data types and those of the chosen DBMS.
In Sybase Adaptive Server Enterprise 12:
| PowerDesigner data type | ASE 12 data type |
|---|---|
| sysname | VA30 |
| integer | I |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |