Salesforce

Time - DB2 (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Time - DB2 (Magic xpa 4.x)

The table below lists Magic xpa’s Time 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 Time

HH:MM:SS

6

TIME

Integer Time

HH:MM:SS

4

BINARY

HMSH Time

HH:MM:SS

4

BINARY

Magic Time

HH:MM:SS

4

BINARY

Note: If you want to map Magic xpa’s String Time to the DB2 TIME datatype, you can also specify ‘MGTIME’ as the Type property under the column properties/SQL.

Reference
Attachment 
Attachment