Chapter 3 DBMS Resource File Reference

Script/Data Type Category

The Data type category defines mappings between PowerDesigner and DBMS data types.

The following variables may be used:

Item Description
AmcdDataType Lists mappings between PowerDesigner data types and DBMS data types.

These mappings are used during CDM to PDM generation and with the Change Current DBMS command. The following variables are used to qualify the data type:

Examples (ASE 15→PowerDesigner):

  • A%n→char(%n)
  • VA%n→varchar(%n)
  • LA%→varchar(%n)
PhysDataType Lists mappings between DBMS data types and PowerDesigner data types.

These mappings are used during PDM to CDM generation and with the Change Current DBMS command.

Examples (PowerDesigner→ASE 15):

  • sysname→VA30
  • integer→I
PhysDttpSize Lists the storage sizes of non-default DBMS data types. Used when estimating the size of the database.

Examples (ASE 15):

  • smallmoney→8
  • smalldatetime→4
OdbcPhysData
Type 		Lists mappings between database data types and internal PowerDesigner data types. Used during live database reverse engineering.

The way data types are stored in the database may differ from the DBMS notation. For example, Sybase SQL Anywhere stores a decimal data type as decimal(30,6).

Examples (ASA 10→PowerDesigner):

  • char(1)→char
  • decimal(30,6)→decimal
PhysOdbcData
Type 		Lists mappings between DBMS data types and PowerDesigner data types.

Examples (Access 2000→PowerDesigner):

  • Integer→Short
  • LongInteger→Long
PhysLogADT
Type 		Lists mappings between DBMS abstract data types and PowerDesigner abstract data types.

Examples (Oracle 10g→PowerDesigner):

  • VARRAY→Array
  • SQLJ_OBJECT→JavaObject
LogPhysADT
Type 		Lists mappings between PowerDesigner abstract data types and DBMS abstract data types.

Examples (PowerDesigner→Oracle 10g):

  • Java→<Undefined>
  • List→TABLE
AllowedADT Lists the abstract data types that may be used as types for columns and domains.

Example (ASE 15):

  • JAVA
HostDataType Lists mappings between DBMS data types and data types used in PowerDesigner procedures and trigger code.

Examples (Oracle 10g→PowerDesigner):

  • DEC→number
  • SMALLINT→integer

 

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