471,050 Members | 1,423 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

SQL DTS to DB2

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.

Aug 21 '06 #1
1 1603
Are you using a Data Pump task in your DTS package?

Does the Destination DB2 table have a PRIMARY KEY on it?

Does your Transformation within the Data Pump Task write to all the required
(NOT NULL) columns of the DB2 table?

Try a simple SQL Task that uses the DB2 connection and one INSERT of one
record of hard-coded values to be sure you have a connection that is more
than just read-only.

"Nali" <St***********@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
>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.

Sep 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.