Restrictions on the Use of DB Interface Module Datatypes

SourcePro : DB Access Module for DB2 CLI User’s Guide : Technical Information : 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