DSXchange

Ordinal position of the key columns in the key is independent of the order that you specify that they be sorted.

You can certainly change the value of a project level parameter (environment variable) from within a job, but the change will not be visible in the job that effects the change. Job parameter values are read into a structure when the job starts.

Take a look at the score for this step (job). What are the operators that make up the composite operator?

The limit is on the physical structure of the key, not on a single key column. That is, MAXKEYSIZE affects the maximum allowable size of @ID. If you increase MAXKEYSIZE (you need to edit uvconfig, shut down the DataStage services, regenerate the system (disk) shared memory segment and re-start DataS...

Probably not. The problem was that a hashed file stage was configured to create a dynamic hashed file (Type 30) but managed not to create .Type30 or, possibly, that some other process soon after managed to delete .Type30 (cause or causes unknown, and unknowable unless it happens again). The descript...

... or are/were you just being impatient? netstat -a can take quite a while to complete even on moderately-sized systems; it has a lot of information to gather.

There is NO SUCH THING (yet) as a 64-bit installation of DataStage on AIX. DataStage on AIX is a 32-bit application and therefore needs to use 32-bit libraries.

No, and you've destroyed the evidence.

Something else. Open your Administrator client and set the inactivity timeout to a longer interval.

Then please mark this thread as Resolved

upstream_activity_Done (unconditional)
upstream_activity_OK
upstream_activity_Error
upstream_activity_NonFail (custom: OK or warn)
etc.

(I don't mean literal activity names, more the task that it performs.)
Outputs from a Nested Condition activity should reflect the condition.

Nowhere in what you have described is there any need for any kind of Max() function. You are performing a vertical pivot. It is possible to implement what you have described in Transformer stage (ideally with an upstream Sort stage generating a Key Change column and a downstream Remove Duplicates st...

And you can also do it with a job, which was your original question, but you will need to write a couple of routines to gather information as each job is processed through your new job (which must be smart enough not to process itself, lest you introduce infinite recursion).

juan_pera wrote:Goodday All,

Does anyone know if it is at all possible to execute a DataStage Server Routine (Function) from the command line ?

Regards
Juan Pera

It is not possible.

One file, one character set. Tell the providers of the file. DataStage does have the ability to use different character mapping in different columns, but not in different rows. If you know which rows they are, split the file and process through different Sequential File stages with different map set...