Chapter 3 DBMS Reference Guide
Data type translation table showing the mapping of PowerDesigner internal data types to the DBMS definition file data types. This is used during CDM to PDM generation and with the Change Current DBMS command. 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:
| ASE 12 data type | PowerDesigner data type |
|---|---|
| A%n | char(%n) |
| VA%n | varchar(%n) |
| LA%n | varchar(%n) |
| BT | tinyint |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |