DSXchange

No time for a full answer, but I get the impression you're not familiar with named pipes so thought something like this might help:

http://en.wikipedia.org/wiki/Named_pipe

Wasn't all that hard to find where it had moved to:

http://www.openqm.org/downloads/dynamic_files.pdf

Realize that this is a technical paper from a completely different product.

If you need any help making the actual changes required for this, let us know.

And? Works now?

I usually tar'em up first and then move the tar file, it picks up everything automagically.

Wiki wiki wiki...

http://en.wikipedia.org/wiki/Hash_table

It's not Version Control per se, it's the fact that they are Read Only by default after promotion. Use the Multi-Job Compiler option in the Manager to recompile them. I don't see the point, however, as they should only need to be Reset, not Recompiled but whatever.

Sure, and the conversations on the subject are out there. You need to determine delimiter does work on your system. It could be a space, a comma, a semi-colon... one of those should work. Or a combination, for example you may need a space after the comma or you may specifically need to exclude the s...

Maybe.

First off - Welcome. :D

A mantra here: Search is your friend. An Exact Match search for "Unable to allocate Type 30 descriptor, table is full" will reveal all.

Hmmm... I'm not sure anything like DataStage needs to explicitly support or be 'compliant' with Real Application Clusters, it should be transparent to it. There's still only one physical database, it's just that there's multiple logical instances of it running and Oracle is deciding who / what runs ...

I was being sarcastic. And did you not see Ray's reply? You 'schedule' it by having an Operator perform the function on a regular basis.

Arnd basically said there is no such thing in DataStage. Where did you hear of them, in what context?

No problem. Please mark the thread as Resolved when you get a chance.

Ok. Do you realize you don't need any kind of special routine to do this? Simply put two hashed file stages on the canvas, attached to the same transformer, referencing the same hashed filename. One is a reference link, the other an output link. When the lookup fails, write the record to the output ...

ORA-1403 - "no data found". Usually more of a PL/SQL than a SQL error. You may want to ask your DBA about it. Oracle errors are easy to find online and there's a manual for them as well. Assuming your Oracle environment is properly setup you can also do "oerr" from the command line: oerr ORA 1403 01...