DSXchange

Zen




... or possibly Samizdat

You don't have to. But you can. There is no relationship whatsoever between processing nodes in the configuration file and the number of CPUs in the server. Too many processing nodes per CPU may well swamp the machine; too few may under-utilize the machine; somewhere between too many and too few the...

Answer without noticing question.

The actual Catalog name is DSX.CONVERT.MONTH (there are some strange "standards" behind the Built-In and Example categories).

The Catalog name is case sensitive.

My feeling would be that one is better than many, because of the amount of work avoided buffering data between processes. Of course, diagnosis becomes ugly - but if it's only failed lookup you're interested in, then you have a Merge stage.

Welcome aboard.
If there's only one record format, Sequential File stage is to be preferred.
Just make sure that, when you import the "table definition", you get the field widths correct.

That is "use a different configuration file", not "run the whole job in a node pool".

If the target is Date, then there is no valid reason to require a different format.

The largest (signed) integer is 2^31-1. Your job has supplied a decimal value larger than this.

No.

DataStage generates processes. The operating system allocates these processes among the available processors.

Of course, you may wish to look at creating configuration files that make better use of the enhanced capabilities, but there's nothing you have to do.

DSR_EXECJOB.B is the program that runs jobs. If you delete it you will never run another job in that project. RT_CONFIG396 is a dynamic hashed file that contains the runtime configuration of job number 396. If you delete it job number 396 will be almost irretrievably corrupted. Of course they will b...

A join does not have any rejects. A row is either in the join or it isn't.

Don't even think about automating this until you have determined the reason that jobs might be running over time. It might be something serious that requires attention.

There are sample questions on the IBM certification web site.

Do not use pay sites that claim to have certification questions; they do not.

The actual questions are heavily protected by IBM.

You could read the entire record as a single string, then use the Index() function to test for the existence of "HEADER" or "TRAILER".

Or you need to make sure that your column width definitions properly define the seven character field in which the record type is to be found.