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
- Using the case-insensitive character string data type prevents the DataServer from performing selection by server.
- 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.
- The size of a signed 2-byte field cannot exceed 4 digits.
- 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.
- 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 |