i'm using db2 odbc driver perform select , insert/update operations excel. i've noticed select operation truncates text fields 250 chars when field defined hold 15000 characters. insert/update operations fail if try store strings longer 250 chars fields. there web interface database can select , insert/update fields without restrictions on size of strings (obviously, provided less 15k long).
i want know restrictions coming , how overcome them when using odbc access.
product versions:
windows 7
ms excel 2013
db2 version (as returned select * sysibm.sysversions
): 10050500 (s141128).
ibm odbc driver 10.05.800.381
Comments
Post a Comment