DB2/400 Databases (Magic xpa 3.x)
The following are the default Data Types and mapping for the DB2/400 database:
|
Magic xpa data type
|
Stored as (default)
|
Picture with DB2/400 gateway
|
Defult mapping to DB2/400 data type
|
|
Alpha
|
String
|
1 to 32000
|
CHAR(n)
|
|
Alpha
|
String Memo (n+2)
|
1 to 32000
|
VARCHAR(n)
|
|
Numeric
|
Packed Decimal
|
1
|
DECIMAL(1,0)
|
|
Numeric
|
Packed Decimal
|
2 to 3
|
DECIMAL(3,0)
|
|
Numeric
|
Packed Decimal
|
4 to 5
|
DECIMAL(5,0)
|
|
Numeric
|
Packed Decimal
|
6 to 7
|
DECIMAL(7,0)
|
|
Numeric
|
Packed Decimal
|
8 to 9
|
DECIMAL(9,0)
|
|
Numeric
|
Packed Decimal
|
10 to 11
|
DECIMAL(11,0)
|
|
Numeric
|
Packed Decimal
|
12 to 13
|
DECIMAL(13,0)
|
|
Numeric
|
Packed Decimal
|
14 to 15
|
DECIMAL(15,0)
|
|
Numeric
|
Packed Decimal
|
16 to 17
|
DECIMAL(17,0)
|
|
Numeric
|
Packed Decimal
|
18
|
DECIMAL(19,0)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total up to 2 digits e.g 0.11
0 + 2 = 2 digits)
|
DECIMAL(3,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 3-4 digits e.g 1.113
1 + 3= 4 digits)
|
DECIMAL(5,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 5-6 digits e.g 142.13
3 + 2= 5 digits)
|
DECIMAL(7,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 7-8 digits e.g 14213.353
5 + 3= 8 digits)
|
DECIMAL(9,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 9-10 digits e.g 142133.5388
6 + 4= 10 digits)
|
DECIMAL(11,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 11-12 digits e.g 142.133538811
3 + 9= 12 digits)
|
DECIMAL(13,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 13-14 digits e.g 142133.53881133
6 + 8= 14 digits)
|
DECIMAL(15,n)
|
|
Numeric
|
Packed Decimal
|
#.#
(Total 15-16 digits e.g 142133538.8113348
9 + 7= 16 digits)
|
DECIMAL(17,n)
|
|
Logical
|
String Logical(1)
|
5
|
CHAR(1)
|
|
Date
|
String Date (8)
|
## / ## / ####
|
DATE
|
|
Time
|
String Time (6)
|
HH:MM:SS
|
TIME
|
|
BLOB
|
BLOB
|
12 Default
|
BLOB
|
|
|
The Magic xpa Single User Edition does not support the DB2/400 database.
|
