DSXchange

Then build yourself the lookup you need. Take the Oracle errors you typically encounter plus their "real description error" and put it somewhere. Then build a hashed file from that source and use it in your reject link.

Dynamic Relational Stage. It allows you to switch underlying native interfaces on the fly and supports ODBC as well.

Post your job design. IDENT3 would be an "invisible" transformer inserted between two passive stages by the compiler, however that can't be the only message that was logged, right?

When you reply, keep in mind the fact that these "generic jobs" not only have to service different source tables but different source databases as well - Oracle, SQL Server, etc.

Ayan, I assume you'd be using the DRS stage? Have you done any kind of a 'POC' for this yet?

Ah... that's why it sounded vaguely familiar - you're talking PX and this is a Server issue. Perhaps even a Server non-issue.

That sounds vaguely familiar but no clue where that setting would be. Would not "math" also fix that, for example multiplying by 1?

How is LIKE any different (functionally) from the previous INDEX usage?

I don't recall the descriptive text being in any of the link variables available from an Oracle reject. Many are empty. Perhaps it should be there but honestly don't think it is.

True, the only answers here are dsjob related.

I mean build a lookup table of all Oracle error codes with their descriptions (or at least an appropriate subset) and use that to get the descriptions that you need in the reject link. I have no idea how easily you could get your hands on such a list, worst case someone could use a document such as ...

You will need to build a lookup for that... emphasis on the "you" part.

Rocket Software owns Universe now. A search here for that should turn up some links or you could check their website.

Check with others in your organization, it's part of the standard client set for the 7.x version.

Pre 8, the version won't matter so yes, as long as one is done as an "itag" installation. There's a pdf document that explains how to do that - multiserv.pdf off the top of my head.