Logical - DB2 (Magic xpa 2.x)
The table below lists Magic xpa’s Logical 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.
Note: n is the specified picture number.
|
Magic xpa Storage Type
|
Magic xpa Picture
|
Magic xpa Storage Size
|
DB2
Data Type
|
|
Integer Logical
|
5
|
n,1-2
|
CHARacter(1) FOR BIT DATA
|
|
String Logical
|
5
|
1
|
CHARacter(1) FOR BIT DATA
|
