DSXchange

What database? And just as an FYI and AFAIK, the DRS stage always uses the ODBC style parameter markers which are unadorned positional question marks - no colons or numbers or anything else.

... and what you get without any DataStage 'formatting' is one long record, which is what any parser is actually looking for. Formatting ('pretty printing') is for for peoples.

Index() can find it for you and will return the position it was found in as a bonus, but you can simply treat any non-zero return value as 'true' if you like.

Are you actually targeting an Oracle LONG data type, or is it a CLOB or just a large VARCHAR2?

Ah... there's part of the problem - you can't trim CHAR fields and you'll have issue with 11 v. 15, so either make them the same size or treat them as varchars in your job and then trim.

The Devil *is* in the details.

In Windows, that would be 'type' rather than 'cat' unless you have MKS installed.

Being new, why do you think you 'need' to do this from a routine? It's not the most straight-forward approach you could take.

Please start your own post.

Time to mark this as Resolved using the button at the top of the screen!

OK. Those would need to be uploaded to an image hosting site and then you can use the [Img] tags to link to them. Or just explain things in words to us.

Not quite sure how that is supposed to help.

(it doesn't)

Welcome aboard, Adnan, but a couple of things: This post is well over a year old, is a Server question you tried to give a PX answer for and it's clearly marked that they are working in "DS v7" rather than 8. And more precisely it is the Remove Duplicates stage. Generally best to stick wit...

There's no other explanation if you've verified the other points already mentioned: * The metadata is exactly the same, hashed file writer and reader jobs. * The hashed file name is exactly the same, reader and writer. Really, all that's left is key data not matching. So... how about some specifics ...

Search for your error message, this has been asked and answered many times here already. For example, there were 26 matches for an Exact Match search for "The system cannot locate the resource specified".

How is this any different from your previous question?