DSXchange

No.

Well, unless perhaps you have a backup of the repository from before the deletion and then it would depend on where your logs are being stored.

Meaning perhaps the codeset / characterset used in each database is different. As in one might be multibyte and one may not be... you should be able to check with your DBA.

Sounds like your staging data doesn't all fit in the work table. Are you certain you have all of your metadata correct and it should in fact fit without truncation? For example, a CHAR(6) to a CHAR(4) would cause that.

If all that is good you may have a codeset issue.

What stage is it happening in? What kind of 'conversion' are you doing? The error implies you are not doing an explicit conversion but instead are relying on an implicit conversion by simply moving it from one data type to another... and it has no clue how you want it to convert one to the other.

At least there's a machanism nowadays to increase the limit. 'Back in the day' it was hard-coded to 60 seconds, athough we could (and did) make uvconfig changes as the article notes to help with it. From what I recall, the event it gives up waiting on is the call to request the job be started coming...

Interesting. Simple enough to test should you feel the need / desire.

I also wonder how much (if any) of this answer is specific to DB2 and/or the Connector architecture.

Of course they are. And we've seen this movie many times before - something was broken in 8.x and you were taking advantage of the bug, a bug they've fixed in later versions. You really should be doing explicit conversions when moving a string to a date or vice-versa.

Those multiple action modes, like Update then Insert, simply try both actions in the order noted. So it will attempt the update first and only if that fails will it attempt the insert. Guessing you already know that so just putting it out there for completeness. As to the outcome in that case, if ev...

In the past there was a tool called the Multiple Client Manager or MDM and that is exactly what it was for - to switch between installed clients since only one can be active at any given time. Sorry but I have no clue if it is still around or if it works with the current versions.

Clarify the order you did things and if we're talking the entire product or just the client. I'd also be curious if "removed" means uninstalled or something else. 1. Installed 8.1 and two patches 2. Installed 11.3 3. Removed 11.3 :?: No need to reinstall Windows but I'd wager you need to r...

OK, good to know.

You'd have to disable that option when you did the conventional inserts for a true test... and fairly certain you'll find conventionals work fine without that setting.

Interesting... still curious as to the answer to my question.

Which (from what I recall) only applies to bulk loads. Are these bulk loads or conventional inserts?

A pet peeve. You're not chatting with your buds or tweeting so there's no reason to spell "your" like that on a (semi) professional peer-to-peer support site. Did you try setting the field's delimiter string property to that? Without the extra quotes you have in your post? I would imagine ...