DSXchange

This has nothing whatsoever to do with DB2. Read the error message carefully - "no remote shell found". DataStage is unable to find or execute a remote shell command through which the conductor process can communicate with player or section leader processes on other nodes. In your particul...

Provide a Null Field Value containing ten characters.

The 4 in your integer definition is bytes, not characters. A 32-bit (four byte) integer can have as many as ten digits.

What's the actual error message? "a wierd problem" (however you spell it) is not useful for diagnosis. You might also post the SQL used, as your fragment just looks plain wrong.

What's the issue? It's perfectly feasible that an inner join only returns eight rows. This indicates that there are only eight common key values. Likewise a left outer join by its very definition returns all rows from its left input.

The easiest is to examine the History section in Version.xml. This will report SUCCESS or some other status. If the installation includes DataStage, create two jobs, one with a Transformer stage and one without, to verify that your C++ compiler is correctly installed and configured.

You don't. Who said you did? For example if you want to make a change to uvconfig, it's sufficient to stop only DataStage services.

The first dot is a synonym for the source command. Read man source to determine what it does.

Or don't even worry about the values, just report them.

It's the same as using a loop, but why code the loop when you know that there are only two lines in the file?

You can re-initialize the state file.

That's what Eric's solution will give you.

Neither. This is a question about the programming language, not about job design.

I can't see where you've sourced the dsenv script.

This is essential before attempting to use the dsjob command.

What are you trying to do in the activity variable? I do lots of these, and parsing isn't an issue. What do you expect the value output in the activity variable to be?