DSXchange

You don't need DataStage to do that. It's straightforward DML.

DataStage is an ETL tool, not a reporting tool!

You can do this in a Routine activity - check out OPENSEQ and SYSTEM() in the DataStage BASIC manual.

I keep WAS and XMETA together for preference (for performance), but have the engine tier on other server(s).

Use the version number in the job/routine properties. Increment the tertiary number whenever there's a change and export.

Find out what Oracle error number -911 actually means - use the oerr command to get a recommendation about what to do about it.

Why do you think you need DataStage to do this? What you're doing seems (to me, at least) to call for some very straightforward SQL statements. And a bit of thought about the order in which they're executed.

Check too whether your other client is set to automatically truncate to legal names.

I am currently in Finland for the first time. On Sunday - pre-arranged through DSXchange - I had two delightful tour guides to show me around Helsinki. It was a very enjoyable day, made even better by perfect weather (not claiming credit for that) and the generosity of my hosts in taking a day out o...

Is rsh properly set up between "test" and "chevelle"? What error messages are produced?

The separate processing nodes are separate. The only way you can accomplish what you are doing is to run on one node only. Unless, of course, you can figure out a way to wrap the entire DataStage job in a single transaction.

There's another book that goes with "four nodes good, two nodes bad". No, wait a minute, that was legs!

"Read" how?

Resist stupid requirements!

Try using a large VarChar for retrieval.

In the same boat, but working for some high powered (three star) officers, so slightly better chance of getting things approved. Like Information Server client, for example. (Sheesh.)

However, we DO have both Control Center and its younger cousin Data Studio installed.

Transformer stage can do the job of a Row Generator stage.

Some of them - eight from memory - yes. Which ones is documented in one of the manuals, but I can't check which one at the moment (in airport lounge). Maybe the Oracle Connectivity Guide.