Progress/400
Product Guide


DB2/400-to-Progress Data Type Mapping

Table 2–2 shows how the DataServer maps data types in existing DB2/400 database files to Progress data types when you create a client schema holder. For each DB2/400 data type, the table lists the DDS equivalent, the Progress/400 label, and the DataServer implementation.

Table 2–2: DB2/400-to-Progress Data Type Mapping
DB2/400 Type
DDS Type
Label
Progress Equivalent
Character
A
Character
CHARACTER
Character
A
Case-insensitive key string1
CHARACTER
Character
A
Logical
LOGICAL
Zoned decimal
S
Zoned numeric
DECIMAL
Packed decimal
P
Packed decimal2
Packed decimal (even digits)
DECIMAL
Binary
B
Signed 2 byte3
Signed 4 byte
INTEGER
Floating Point
F
Short floating pt
Long floating pt
DECIMAL
Date4
L
Date
DATE
Time5
T
Time
CHARACTER
Timestamp5
Z
Timestamp
CHARACTER
  1. Using the case-insensitive character string data type prevents the DataServer from performing selection by server.
  2. The packed decimal data type is labeled packed decimal (odd) or packed decimal (even digits) depending on whether the field contains an odd or even number of digits, respectively.
  3. The size of a signed 2-byte field cannot exceed 4 digits.
  4. Progress supports two display formats for DATE: mm/dd/yy and mm/dd/yyyy. Use the Progress/400 Data Dictionary to specify a display format. If you want to display dates in other formats, you can use the Progress Date Format (-d) startup parameter or you can manipulate the data through your application code.
  5. Progress does not have comparable data types. When you access a DB2/400 database, the Progress client ensures that only valid values can be inserted in fields of this type. However, if you dump the definitions from a DB2/400 database and load the definition to a standard Progress database (non-schema holder), these data types are implemented as character fields and lose the error checking.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095