Error from DTS-Export from Sql Server to DB2

Kallia Dimoka

Error from DTS-Export from Sql Server to DB2
Hello and Many Greetings to you all!



DB2 7.1.1 on Z/OS 1.4

DB2 Connect PE 8.2 (on Win XP and 2000)

Sql Server 2000 (SP3) - (same case also tested on Sql Server 7 )



I am trying to export a table from SqlServer to DB2 (something i have done HUNDREDS of times in the past - certainly without connect 8.2!)

No matter what , when trying to copy a table , i am always getting the following error



"Error at Destination for Row number 1. Errors encountered so far in this task: 1."



After trying to do the an export from Sql Server to local Db2 Personal Edition , i got the following , a little bit more enlightening message :



"Error at Destination for Row number 1. Errors encountered so far in this task: 1.

[IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00 "



Now, what???



Since i don't have any more ideas available, i would love to receive yours....

(it would be a great Christmas gift!!!)



Best Regards,



Popi A. Dimoka
ÉNTERAMERICAN S.A
Tech Support Dept
Certified Db2 DataBase Admin
Doiranis 240-Athens, Greece
*+30-210-9461673
* [login to unmask email]




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Vaughan

Re: Error from DTS-Export from Sql Server to DB2
(in response to Kallia Dimoka)
Try adding DISABLEKEYSETCURSOR=1 to your DB2CLI.INI file. This solved a similar-looking issue for us when using DTS with DB2 Connect v8.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of [login to unmask email]
Sent: Friday, December 24, 2004 5:21 AM
To: [login to unmask email]
Subject: Error from DTS-Export from Sql Server to DB2



Hello and Many Greetings to you all!



DB2 7.1.1 on Z/OS 1.4

DB2 Connect PE 8.2 (on Win XP and 2000)

Sql Server 2000 (SP3) - (same case also tested on Sql Server 7 )



I am trying to export a table from SqlServer to DB2 (something i have done HUNDREDS of times in the past - certainly without connect 8.2!)

No matter what , when trying to copy a table , i am always getting the following error



"Error at Destination for Row number 1. Errors encountered so far in this task: 1."



After trying to do the an export from Sql Server to local Db2 Personal Edition , i got the following , a little bit more enlightening message :



"Error at Destination for Row number 1. Errors encountered so far in this task: 1.

[IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00 "



Now, what???



Since i don't have any more ideas available, i would love to receive yours....

(it would be a great Christmas gift!!!)



Best Regards,



Popi A. Dimoka
ÉNTERAMERICAN S.A
Tech Support Dept
Certified Db2 DataBase Admin
Doiranis 240-Athens, Greece
*+30-210-9461673
* [login to unmask email]



--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm