HOPEX V4 Doc EN

HOPEX Information Architecture > Data Architecture > Attribute and Column Types > Determining Column Datatypes from Attribute Types > Pivot Types

Pivot Types

Pivot types are datatypes defined independently of the target DBMS, which you can use when you do not yet know the system in which the database will be hosted, or when several systems may be used.

Pivot types have an equivalent datatype in each supported DBMS. They therefore enable you to define the attribute types just once, then to reinterpret them later as a function of the target DBMS.

To use the datatypes of a DBMS, you must import the corresponding solution pack. See "Importing a DBMS Version", page 213.

List of pivot types

Once imported, the pivot types are available in the Logical data navigation pane, in the "Pivot" datatype package.

Alphanumeric types		Other Information
P-String	Alphanumeric character chain
P-Text	Alphanumeric character chain
P-Character	Alphanumeric string of fixed length	Length
P-Varchar	Alphanumeric string of variable length
Numeric types
P-Decimal	Decimal
P-Double
P-Float
P-Integer	Short
P-Long Integer
P-Long Real
P-Real
P-Smallint
P-Tinyint
P-Numeric	Number	Length, decimal places
P-Currency	Amount expressed as currency	Length, decimal places
Date types
P-Date	Date
P-Time	Time
P-DateTime	Date and time
Binary types
P-Binary	Binary string
P-Byte	Binary string
P-Timestamp	Identification automatically generated from the date and time, expressed in thousandths of seconds since January 1, 1970
P-Boolean	Boolean, equals 0 or 1
P-Multimedia	Binary string
P-Varbinary	Binary string