All kinds of AS/400 field types are supported. For the field types that don't exist on AS/400, they are converted to the nearest field type.
Null capability is also fully supported: you can get or set null field information with tables and queries. You can even make a key search with null values.
Depending of the AS/400 type of a field, it is converted (in read and write) to a PC type. Conversion between AS/400 types and PC types are made by the client.
You can notice that PACKED or ZONED fields are optimally mapped to a type depending on the size.
From Bde version 5 PACKED or ZONED field that have no decimal but a number of digits between 16 and 18 are mapped to 64 bits integers.
|
AS/400 type |
Size |
Dec |
PC Type |
|
CHAR |
Any |
ZString (pChar) |
|
|
BIN2 |
INT16 |
||
|
BIN4 |
INT32 |
||
|
PACK or ZONED |
1->4 |
0 |
INT16 |
|
PACK or ZONED |
5->9 |
0 |
INT32 |
|
PACK or ZONED |
10->15 |
Any |
DOUBLE |
|
PACK or ZONED |
Other cases |
ZString (pChar) |
|
|
DOUBLE |
DOUBLE |
||
|
FLOAT |
DOUBLE |
||
|
DATE |
DATE |
||
|
TIME |
TIME |
||
|
TIMESTAMP |
DATETIME |