DSXchange

Physically no difference. Each is a stream of bytes. The term "flat file" stems from the fact that they must be processed sequentially - one must read past each byte to get to the next. CSV and XML files are also flat files in this sense. The terms CSV and XML (and there are others) refer to the way...

My choice: export minus executables, compile in new environment. We're fairly rigorous about recording and picking up dependencies, but the compile picks up any that are missed (for example there's no mechanism within the product to record dependent Transforms).

No. Server jobs do not support dynamic metadata.

We don't do "asap" or "urgent". DSXchange is an all-volunteer site whose members may post as and when they can, and then only if they have something to contribute. If you want urgent help, sign up with your support provider for priority service, and learn the true cost of "urgent". Your support pro...

Therefore please (a) mark the thread as Resolved (green button at top) and (b) add a post indicating HOW it was resolved, to aid future searchers.
Thank you.

Welcome. A Search for 40503 yielded 21 hits (including this thread). Is there anything in any of those that matches your situation?

The OLE server in this case is highly likely to be dsobjects.dll or one of the OLE servers that it in turn invokes. Therefore Arnd's comments are pertinent.

What aggregate weights did you get for these "duplicates"? How common or rare is "Michelle" in your data?

Did you bother to Search DSXchange before posting this question? This error has been posted a number of times in the past.

Yes.

You use "indirect call", which allows the value of the routine name to be loaded into a variable before the CALL statement is executed.

Find out more from the DataStage BASIC manual. You will also find examples if you Search DSXchange.

Not from me.

You want to write your own function then go ahead, it will encapsulate the expression logic I gave.

Whether or not U has any other ideas remains to be seen: U does not log in all that often.

QualityStage does have Soundex, but you are not using it as your blocking columns. Did you intend to? Soundex is Soundex, no matter which vendor it comes from; the algorithm is in the public domain. NYSIIS is a more sophisticated algorithm than Soundex (primarily because it looks at more characters ...

U did not ask the question. Deepa_Vaidyanathan did. Can you please explain how a Pivot stage (presumably alone, based on what you said) can be used to solve this particular problem, rather than simply assert?

What is to happen if the first character is non-zero? You did not include this in your specification.

Use the UNIX command grep. DataStage installs with MKS Toolkit, so you have the full repertoire of UNIX commands available. If you must use DataStage, which is akin to using a sledgehammer to crack a walnut, simply use the Index() function in a Transformer stage to determine whether the string in wh...