DSXchange

Sounds like a pretty normal NLS issue to me... what is the characterset you are working with?

So... have you solved whatever dsjob command issue you were having?

I don't think they have an issue with the message itself, meaning they know why it was thrown. The question is why is the message strangely formatted with an extra space between each and every character? That doubles the length of the string needed and (apparently) cuts it off. I'd still suggest you...

Ok.

They did and they already shared.

As noted, we'd need to know what in the heck "not working" means before anyone could help.

You might want to check with your official support provider and see if this is an issue with the DB2 connector. It should only log anything if both operations fail. Any 'failure' in the first operation should simply trigger the second operation without complaint or there's really no point to those '...

Initial value? No. They are updated for each row processed through the transformer but they only get their initial value once. Hence the name.

Why do you asK?

Your guess is correct.

Make sure someone updates the Oracle related information in your dsenv file - ORACLE_HOME, load library, etc - in reference the new location.

Ray has explained this many times, most recently here. Search.

If you have a similar issue, create your own post. Tell us all about it.

Ignoring all of the Star Wars nonsense, there is a little nugget about the ODBC text driver buried in there. If you have issues with the CC stage, you might want to check it out.

While I believe you could do this by jumping thru some hoops and sending each file to its own XML Input stage, I don't see the point. Create two jobs.

I edited your post to remove most of the examples as they really weren't needed and they were screwing with the formatting of this page making it hard to work with.

It would be helpful to know what database you're talking about and if you allowed the stage to generate the syntax or if you are typing it in manually. For the latter try the former.