DSXchange

Looks like a UNIX linefeed delimiter rather than DOS style CR/LF pairs.

No, not right. You'll need to run the job in question as I noted in my first reply so that you can run it with unlimited warning allowed. That or "fix" the job so the warnings are reduced or eliminated. Or perhaps just demote them with a message handler.

As noted, you'll either need to craft your own or I'd wager there are third-party libraries out there you could leverage in a BuildOp or something similar for an exchange of currency.

Hmmm... loop #257... one past #256... sounds suspiciously like an overflow problem to me. And it is! And there's a patch for it! Woohoo!

Details here including the eCase number to ask about.

1) I'm assuming a new reply was added in between the times you checked. 2) Only the Premium Posters can mark content as Premium Content. There are what five (six?) of us now and it is at our discretion as to which posts get marked which way. For example, I decided to not mark this one as "PC" so eve...

I don't believe that generalization of ODBC being "slower" is still valid. I prefer "native" stages but some folks are not willing to install the database clients they need on the DataStage server. What's new should all be documented in the release notes.

What Sequence warnings are you trying to suppress? That option won't stop normal Sequence errors/warnings from being logged, but rather not log problems from the activities the Sequence ran.

By default, all Job Activity stages inherit their Warning Limit from the calling Sequence. So you could do that for all by starting the Sequence with no warning limit, but you couldn't do that for one Job Activity stage out of the group. AFAIK, you'd either need to use an Execute Command stage to ru...

Still talking hardware resources - CPUs, memory, disk, etc. How differently are the virtual servers configured? There's no "fix" that I'm aware of being needed.

Still don't see the O/S or DS version playing a major role here. What about the resources allocated to both virtual servers?

BASIC Transformer would mean a Server routine written in BASIC. And I'd wager they didn't.

"Accessed"?

Column derivation? As noted, hashes are not needed there, so it will work fine without them. Have you tried it yet? What happens?

Where exactly you are trying to use it? Not all places need the hashes, column derivations don't. When in doubt, use the "..." Helper, it will always get it right.

What are the differences between the old server and the new server? I would assume your answer lies there.