DSXchange

Trim() will get you to a single space. Convert() can get to "".

Wrong. You expect every 10th row.

This really begs a separate thread. On the server forum. Investigate the Compare() function. Decide your business rule for casing in the output and generate that.

View Generated OSH must be enabled in Administrator. <color=blood> Premium membership costs only a few cents per day, and is 100% devoted to the bandwidth costs of DSXchange. So if you want to see this site continue, please sign up. And you get to read all of the premium posters' posts. </color>

How much benefit is there to using a Distributed Hashed File in this situation? I've got a similar issue where multiple copies of a particular hashed file are being created by a MI job that mod's the input stream and distributes the result across the X hashed files. However, the final job that cons...

DS.CHECKER checks for orphaned DataStage repository objects. However in your case it did not complete correctly, apparently because an earlier run had been interrupted.

You will need to delete all references to DS_JOBS.cleanup (including the VOC entry if any) before proceeding with DS.CHECKER.

That's not corrupted. That's because you have imported only the executable component, not the design component.

Indexing/reindexing will not help.

... the ever-hasty guruji ...

A company like Peoplesoft would have exactly such a requirement.

As everyone knows, a DataStage server machine is capable of delivering an infinite amount of CPU, memory and disk resources on demand. Therefore you can run as many instances as you wish. In practice, however, you may find my opening assertion to be somewhat short of the mark, so pay attention to th...

Is this in a routine or in a derivation expression? Your answer to that will affect what is the correct answer to your question.

Welcome aboard. Please give examples. Recompiling a Routine overwrites the old object code, so the only way it could be executed is by a process that was already using it when the Routine was recompiled. You only need to recompile a Routine if its source code is changed. You should only recompile a ...

Or simply inspect the record schema. Open the table definition record in the Repository, choose the Layout tab, and select the Parallel option.

Read Chapter 10 of the Parallel Job Developer's Guide in which it asserts that OCCURS DEPENDING ON is supported.

To manage the varying data type, you may need to create a custom, hybrid FD with appropriate REDEFINES, rather than trying to shoehorn four different copybooks into one stage.

Use 25 separate jobs appropriate to the 25 different sets of metadata (record schemas). It's more maintainable in the long run.