The ITP/SDK for iSeries does not support all field types supported by DB2 UDB for iSeries. The following view lists the possible DDS field types and how ITP supports them:
Packed Decimal |
(P) |
Supported by ITP |
|
Zoned Decimal |
(S) |
Supported by ITP |
|
Binary |
(B) |
Supported by ITP |
|
Floating Point |
(F) |
Not supported by ITP |
|
Character |
(A) |
Supported as ITP Text Field |
Variable length fields (VARLEN) are not supported as Formal parameter (1) |
Date |
(L) |
Supported as ITP Text Field |
Not supported as Formal parameter (1) |
Time |
(T) |
Supported as ITP Text Field |
Not supported as Formal parameter (1) |
Time stamp |
(Z) |
Supported as ITP Text Field |
Not supported as Formal parameter (1) |
Hexadecimal |
(H) |
Supported as ITP Text Field |
Not supported as Formal parameter (1) |
DBCS-Only |
(J) |
Not supported by ITP |
|
DBCS-Either |
(E) |
Not supported by ITP |
|
DBCS-Open |
(O) |
Not supported by ITP |
|
DBCS-Graphic |
(G) |
Not supported by ITP |
|
(1) This means that *DBMS400 cannot handle Formal parameters of this type nor can the data retrieval programs generated with the SDK. Building a data retrieval program manually is the only option here.