I created an ODBC connection to a DB2 instance running on Linux. Using SQL 2000 DTS package,I can read data from DB2 and populate SQL tables. However when I try to write to DB2 tables, I get the error:
The number of failing rows exceeds the maximum specified. [IBM][CLI Driver] CLIO15OE Driver not capable. SQLSTATE=S1C00
The DTS is able to create tables on DB2, but can't populate them. Also, using Microsoft Access, I can write from SQL to DB2. Why can't I do it with the SQL 2000 DTS?
I've tried DB2 versions 7 and 8.
Thanks.