Salesforce

Date - DB2 (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Date - DB2 (Magic xpa 4.x)

The table below lists Magic xpa’s Date attribute and the valid data types in DB2. Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.

Magic xpa Storage Type

Magic xpa Picture

Magic xpa
Storage Size

DB2 Data
Type

String Date

##/##/####

8

DATE

Integer Date

##/##/####

4

BINARY

Integer Date 1901

##/##/####

4

BINARY

YYMMDD Date

##/##/####

4

BINARY

Magic Date

##/##/####

4

BINARY

Magic Date 1901

##/##/####

4

BINARY


Note:


If you want to map Magic xpa’s String date to a DB2 character, specify ‘CHAR(8)’ as the Type under the column properties/SQL.

Reference
Attachment 
Attachment