DSXchange

Best is the parallel function IsValid().

Yes, clearly. It should be generating only ONE "same value".

If there are 0 rows on the master input of a Merge stage you would expect there to be 0 rows on its output link.

Similarly if there are 0 rows on the left input of a Join stage you would expect there to be 0 rows on its output link for inner and left outer joins.

This is much easier to do with a shell script than with DataStage. DataStage is a row mover rather than a file mover. Of course, DataStage can control when the script is executed. So can a third party scheduler. It's not possible to provide a solution, because we have no idea of how the filenames-wi...

Can you please explain the Oracle query again? I know English may not be your first language. However, to read a field in SQL you must already have its name, so you could pass that as a literal string. Clearly I am misunderstanding your requirement. I am guessing that you can select what you want fr...

There are quite a few. Probably the easiest is UVFIXFILE, which can't handle 64-bit hashed file.

uvfixfile -f pathname -t 1

1100MB simply won't fit in a cache space of 999MB, particularly if there are two 400MB hashed files already cached there. Disable cache for the 1100MB hashed file, so that it doesn't need to warn when it can't allocate any more and starts working to/from disk.

R all TFM !!!

Even the UniVerse and Orchestrate ones.

You're the integration consultant. Click on Help (in Configure Service Registry) then tell us the answer to the question. Few of us have version 8, and would like to be well prepared!

First guess is that your system is struggling to start enough processes quickly enough. There is an environment variable with TIMEOUT in its name that may help (I'm not doing DataStage this week, so haven't any means to check the exact name - I think it's APT_PM_NODE_TIMEOUT.

Welcome aboard.

Please begin a new thread. This may be an unrelated problem. We frown upon hijacking threads.

The Column Generator in my design simply generates the constant 'X' that you use to execute the Lookup.

Technical Rant
"Holes" DO NOT MATTER in surrogate keys. Surrogate keys are about uniqueness - NOTHING ELSE.
With Round Robin partitioning you are unlikely to get any holes.

Welcome aboard.

Learn the Iconv() and Oconv() functions. They are very powerful.

In a server job just format the concatenation.


Not sure how you established that 06 is pm in your example, but ISO 8601 specifies 24 hour clock for a timestamp.