Salesforce

Alpha - DB2 (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Alpha – DB2 (Magic xpa 4.x)

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

String

n,1-254

n,1-255

BINARY

n, 255-32700

n, 256-32700

LONGVARBINARY

Lstring

n, 1-254

n+1, 2-255

BINARY

Zstring

n, 1-254

n+1, 2-255

CHAR

n, 255-32700

n+1, 256-32701

LONGVARCHAR

String Memo

n, 1-255

n+2

BINARY

Magic Memo

n, 255 and above

n+2

LONGVARBINARY

Reference
Attachment 
Attachment