DSXchange

A DataStage parallel job consists of many processes - there is a conductor process, a section leader process on each processing node, and player processes on each processing node. Just from that description you should appreciate that kill is not the best way to stop a job - how could you be sure tha...

It is indeed 003. It's useful sometimes to know that Ctrl-A through Ctrl-Z are represented in ASCII as code points 001 through 026 (decimal).

You need to ask your Oracle DBA about this. It's Oracle that's closing the connection, not DataStage. The DBA ought to be able to use tracing tools to determine a cause.

Neither float nor dfloat can be guaranteed accurately to represent numbers. Prefer decimal[10,4] (or larger precision if needed). What data types are the four inbound columns?

Looks like a bug. Have you reported it to your support provider and, if so, with what result?

It's an environment variable. You can set it anywhere you like, including /etc/profile, $HOME/.profile and so on. For DataStage processes it should be set in $DSHOME/dsenv.

Arnd should have been more definite. Using these internal, undocumented structures will not work in a future release, because the next release delivers metadata via a service (the Metadata Delivery Service), not out of accessible structures. Nor are the metadata stored in a UniVerse-like database an...

Thanks ray... but in order to seperate inserts and updates I have to again do a look up on the target to distinguish with between inserts and updates. And there by increasing changes of table scanning since my target would have to also serve as look up. THis has the potential of decreasing performa...

You could, but you would probably find it easier to do that in a downstream stage.

Welcome aboard. :D Not dssh.exe on UNIX, just plain dssh - and you probably want to specify exactly the fields from UV_SCHEMA (or UV_ACCOUNT) that you want in the output - for example, you are probably not interested in the numeric ID of the owner or creator. I prefer to give SQL syntax, even though...

You get the documentation with the software. If you haven't got the software yet talk to your vendor, who will be able to supply same. MetaStage is a complex piece of software that, in my experience, can not sensibly be used out of the box without some training. So do schedule that training as early...

After "no data returned" click Yes to view additional information, and post that. There is no way to tell whether your installation has been successful based on the information thus far posted. All we can tell from your last post is that you are generating a row with a single int32 column called COl...

Set up $TZ as a job parameter. Make its default value $ENV, so that it's picked up from the UNIX environment.

Design your jobs so that warnings don't occur. It CAN be achieved.

"Phantom" is the DataStage term for "background process". You know what "error" means. Looks like there's a problem either with the ODBC driver manager or with the ODBC driver for SQL Server itself. Reset the job in Director. Is there any "from previous run..." message containing additional diagnost...