Sybase 7.5 manual Translating OOM data types for a PDM, Translating Java data types for a PDM, 217

Models: 7.5

1 288
Download 288 pages 28.98 Kb
Page 227
Image 227

Chapter 7 Generating a Physical Data Model from an Object-Oriented Model

Translating OOM data types for a PDM

PowerDesigner supports both Java and physical data types. Data types that you select in the OOM are not always supported by the current DBMS. In this case, the data type is translated to a data type supported by the DBMS when you generate the PDM.

Translating Java data types for a PDM

The following table lists the Java data types to which the object language file assigns translations:

Java data type

char

boolean

byte

short

integer

long

float

double

String

Code in

CDM

A

BL

BT

SI

I

LI

F

N

TXT

What it stores

Character

Two opposing values (true/false; yes/no; 1/0)

256values 16-bit integer 32-bit integer 32-bit integer

32-bit floating decimal numbers

Numbers with a fixed decimal point

Character strings

Translation example for SQL Anywhere

char

numeric(1)

smallint

integer

integer

integer

float

numeric

long varchar

217

Page 227
Image 227
Sybase 7.5 manual Translating OOM data types for a PDM, Translating Java data types for a PDM, 217