Salesforce

Logical - DB2 (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

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

Reference
Attachment 
Attachment