DSXchange

We do not even attempt to solve problems reported by this operator. Disable operator combination so that you can discern which stage (operator) is actually generating the error. Also, if you're going to draw your designs using "ASCII art" please enclose the same in Code tags and use Preview to get i...

Add a further specification to the Modify stage containing the single word NOWARN.

If you have an Aggregator after collection to sequential mode you will be able to derive the maximum value from all partitions on its output.

Do you understand what "SCD2" is? The things that you need to do for dimension tables are to capture a before-image of what's current in the target table in a form you can lookup using the business key. As you process the new data you determine whether the business key exists or not in the target an...

No. The email body does not support job parameter references.

You would need to write your own routine for sending mail to implement this requirement.

Neither. It uses DSObjects. DSObjects is the natural successor to UniObjects. UniObjects was the natural successor to UniVerse Objects when VMARK and UniData merged in 1998. There is no direct DataStage equivalent to UniOLEDB, though something of its technology appears in the MSOLEDB stage for inter...

One at a time.

You could build a routine to do it, and run it from its Test grid.

Take a look at the record schema for the Data Set. There is a storage overhead of 80 bits per row. Can you post the size of each of the segment files making up the Data Set (in the bottom frame of the GUI)?

I suspect that these files act as lock files (like those in the UniVerse spooler) while communication with SAP is going on, to make sure that the same connection is opened a maximum of one time.

But I don't know for sure.

Is this the DataStage RPC daemon or some other? If it is the DataStage RPC daemon you might like to change its automatic startup command to direct its stderr to a file rather than the /dev/null. By this means you will be able to tell whether it encounters any error. Check, too, that the UNIX adminis...

Perhaps you need to direct your diagnostic messages to somewhere other than standard output. Many DataStage stages are averse to "unexpected data".

Of course. But your original request sought "any other solution".

Compiled date is field #31 of the RT_CONFIGnnn JOB record for the job.