Salesforce

DB2/400 Databases (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

DB2/400 Databases (Magic xpa 4.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

Default 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.

Reference
Attachment 
Attachment