Salesforce

DB2 Data Types (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

DB2 Data Types (Magic xpa 4.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

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.

Reference
Attachment 
Attachment