DSXchange

No advantage at all in moving to DataStage, if you have, and will continue to have, the skilled resources to maintain the COBOL applications. Can that be guaranteed? It's more likely, in ten years time, that there will be a big pool of DataStage developers around than a big pool of COBOL programmers...

Search the disks where Data Sets are stored. Each Data Set file name includes the name of its control file. Filter on these.

Watch this space.

You can get null on the output, for example if your lookup fails and your "lookup failed" rule is set to Continue.

Mainframe jobs and parallel jobs use a completely disjoint set of stages. There is no comparison. Unless you're running USS, you do not have UNIX commands available for checking files. Record count within DataStage can be easily achieved by aggregating a single column whose value has been set to the...

Any reason not to use PARALLEL=TRUE in your control file?

It's not what I think that matters. It's what DataStage thinks.

Please review your record level and field level properties carefully - you did not answer my suggestion about record length = fixed, for example.

Look in the Director job log and double click on any of the error messages to get detail view.

You can code to get these using DSGetLogEntry() function.

The location of your scratch disk is unlikely to help anyone other than your co-workers on the same server. Location of scratch disk is specified by the configuration file selected when the job is run - it can differ day to day. Also, you need to check all the scratch disks for the node from which t...

So could many of us. But there was nothing in the original post to suggest Oracle. You may be surprised to learn that not everyone in the world uses Larry's database.

A universally-applicable solution was required, and given.

Please elaborate on what you mean by "capture". Do you mean "pre-check" in some sense? That would suggest itself as the approach to take. What is the characteristic that makes it bad - nothing in all five data fields? Or nothing in any one of them? I'd be thinking along the lines of scripting a comm...

Select one of more of these derivations, then right click and choose Derivation Substitution from the menu. This allows you to edit some of all of the selected derivations. For example, if you choose the "entire expression" option and enter NullToValue($1), each expression in the selected set is rep...

Prove that it is the Link Collector stage that is generating the error. Document your job design here, surrounded by Code tags so that the layout is clear. For example: SeqFile1 -----+ | LinkCollector -----> SeqFile3 | SeqFile2 -----+ Use Preview till you get it right, and only then Submit.

The practical limits on the number of hashed files in a job is governed by three factors. The amount of complexity - and therefore ease of maintainability - in the job design. The amount of disk space available for storage of the hashed files. The setting of T30FILE being large enough to have all th...