SourcePro : DB Access Module for DB2 CLI User’s Guide : Technical Information : Datatypes : Restrictions on the Use of DB Interface Module Datatypes
Restrictions on the Use of DB Interface Module Datatypes
DB2 CLI servers place restrictions on the use of certain datatypes. Where possible, the DB Interface Module is flexible about datatypes. However, there are situations in which conversions are not possible, and in these cases your application must be aware of the contexts in which certain datatypes can be used. Table 3 outlines the restrictions associated with each DB Interface Module type.
Table 3 – Restrictions on the use of DB Interface Module datatypes 
RWDBValue::ValueType
Restrictions
Blob
No restrictions
Char
UnsignedChar
No restrictions
Date
No restrictions
DateTime
RWDateTime is limited to milliseconds, however DB2 can support much finer precision. Also, DB2 server supports dates ranging from 0001-01-01-00.00.00.000000000 to 9999-12-31-24.00.00.000000000, but RWDateTime is limited to dates since September, 14, 1752.
TimeTuple
No restrictions
TimeTupleOffset
No restrictions
Decimal
No restrictions
Double
No restrictions
Duration
Not supported by DB Access Module for DB2 CLI
Float
No restrictions
Int
UnsignedInt
No restrictions
Long
UnsignedLong
No restrictions
LongLong
UnsignedLongLong
No restrictions
MBString
Not supported by DB Access Module for DB2 CLI
UString
WString
No restrictions. Refer to Internationalization for more information.
LongDouble
No restrictions
Short
UnsignedShort
No restrictions
String
No restrictions