When a date or time is stored in DB2/400 database in character or numeric format (Not in original Date or Time data type), Easycom needs to know how to convert a date or time constant value given in SQL queries, into the right data type for the AS/400.
Properties NATIVETYPE, DATETYPE and TIMETYPE in extended info can have the following values, depending on the field data type on AS/400:
|
Value |
AS/400 data type |
|
0 |
Character |
|
1 |
Integer 16 bits (2 bytes) |
|
2 |
Integer 32 bits (4 bytes) |
|
3 |
Float simple precision (4 bytes) |
|
4 |
Float Double precision (8 bytes) |
|
6 |
Packed decimal |
|
7 |
Zoned |
|
8 |
Date |
|
9 |
Time |
|
10 |
Time Stamp |
|
13 |
Integer 64 bits (8 bytes) |
When file description is imported, Field level property NATIVETYPE is set to the native data type on AS/400.
In the following example, the field is packed decimal on AS/400:
<EASYCOM>
NATIVETYPE=6
</EASYCOM>
In this example, the field contains a date value (YYYYMMDD) stored as a packed decimal. You need to change the WinDev data type to "Date" in the Analysis. Easycom will convert WinDev dates To/From Packed decimal.
When NATIVETYPE is not set, properties DATETYPE and TIMETYPE in the file or connection extended info, tells the system how date and time values are stored in the database.