DSXchange

The Field() function is documented. Check the "online" help in the Designer for the discussion of the fourth field that Ray mentioned. You've omitted it so it defaulted.

Aha... trick question!

First you'd have to explain for us how you want them retrieved from the command output. Do you want to bring them out all at once? In some sort of delimited list? One at a time because you are looping? It would be helpful to know how the list is being generated and what you plan on doing with it so ...

My question is: why worry about them? If you really want to store the number without them, you'll need to convert it to and store it as a string.

I should add that parameter value files give you another mechanism to solve this problem. The first job could also write those three values to the 'value file' that the parameters could be set to read from, which would make the second step pretty much automatic. I believe in that case the Job Activi...

Which I've explained how to do. Give it a shot!

I'm thinking they mean having a job that is being run by a Sequence pass its output as parameters to a downstream job. If that what is meant then yes, there are ways to accomplish that. Server jobs can leverage the USERSTATUS area and the Sequence can automatically take information from there and pa...

The question was does it compile and run.

but it gives only one record as output. You haven't said how many output records you need nor what you want them to look like. If you need all input records output with the overall minimum value, that's an entirely different process than what we've been discussing. As noted, need more clarity.

Ah... gotcha.

One thing I did see that may be contributing to the issue is Auto-purge of job log not working as set in DataStage Administrator Make sure you understand that the setting in the Administrator is the default that is used when a job is created. It does not apply automatically to all jobs when changed...

Why do you feel that you have to call New Zealand? Every number in the world is listed on their site. Why not simply call the number for India?

Wha... ok, ok, I'm up. Zzzzzz...

Moved

It has, more than once. Baby steps.

FYI - fixed your example. Is there only the single level between Employee and Manager?

Also curious what you have tried so far...