Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-10-15 : 09:10:57
|
| I am trying to load data from 5 SQL Server tables into DB2. I created an ODBC connection to DB2 and use it to delete and load the data from those 5 tables to a DB2 environment. 4 of the 5 tables loads into DB2 OK. The one that doesn't loads 10% of the data and gives the following errorThe number of failing rows exceeds ther maximum specified.[IBM][CLI Driver]CLI0109E String data righttruncation. SQLSTATE=22001.I though it might have been that one of the columns was set to float, so I changed it to INT, but that didn't seem to make a difference.Thanks |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-10-15 : 11:08:27
|
| Also check the columns length.. Might some of the column length is not sufficient to load the data.- Sekar |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-10-15 : 14:16:42
|
| The lengths seem to be the same in both tables. I don't understand why its failing? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-16 : 03:34:32
|
| Have you got Nvarchar in SQL Server, and a plain, non unicode, column in DB2?Only other though I have is that some silent conversion is going on - so a TinyInt is being converted to a (bigger) Int or somesuch.The blasted poxy error message needs to tell you the row, column and data value that it is failing on. And it needs to tell me that too every time I get a similar failure!Kristen |
|
|
|
|
|
|
errror loading data into table