DB2 Data Types (Magic xpa 2.x)
The table below shows the results of a Magic xpa Get Definition operation from a DB2 table, with Magic xpa equivalents for DB2 data types.
|
DB2 Data Type
|
Attribute
|
Magic xpa Storage Type
|
Storage Size
|
Picture
|
|
CHAR(n)
|
Alpha
|
Zstring
|
n+1, 2- 255
|
n, 1-254
|
|
VARCHAR(n)
|
Alpha
|
Zstring
|
n+1, 2- 4001
|
n, 1-4000
|
|
LONGVARCHAR(n)
|
Alpha
|
Zstring
|
n+1, 2- 32701
|
n, 1-32700
|
|
INTEGER
|
Numeric
|
Signed Integer
|
4
|
10
|
|
SMALLINT
|
Numeric
|
Signed Integer
|
2
|
5
|
|
DECIMAL(p, s)
|
Numeric
|
Float
|
8
|
p-s, s
|
|
DOUBLE
|
Numeric
|
Float
|
8
|
According to the Float property in the DBMS Properties (default: 10.3)
|
|
FLOAT
|
Numeric
|
Float
|
4
|
5.2
|
|
DATE
|
Date
|
String Date
|
8
|
##/##/####
|
|
TIME
|
Time
|
String Time
|
6
|
##:##:##
|
|
BLOB
|
Blob
|
Binary Large Object
|
Default (12)
|
|
|
TIMESTAMP
|
1. Date
2. Time
|
Creates two fields, one with String Date and one with String Time, that are connected by the Part of Datetime property.
|
8
|
8
|
|
Note:
|
The storage size is calculated according to the database of the table - according to the gateway's storage table. The storage size is recalculated on import.
|
