Time - DB2 (Magic xpa 2.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.
