DSXchange

Moderator: please move to server forum

This question does not relate to WebSphere Transformation Extender.

I find myself wondering whether the Execute Command activity would accept a single space as the command and everything else in the Parameters field. Hmm... must try it some time.

Take some time to spell out your algorithm. For example it might be as simple as (for each new value of Column 1 begin a new file). It is probably easier to write out a single sorted file then to use a UNIX utility such as csplit or awk to divide it up. Please try to use professional standards of wr...

OK, then start is a good suggestion on Windows (like source would be on UNIX). The start command has plenty of useful options, too. Get to a CMD shell and type HELP START to get more information. You can then put the entire command line that you actually want to execute into the Parameters field of ...

Well, there are known unknowns and unknown unknowns... At least two possibilities spring to mind, one that they have installed 7.5x2 and therefore have MKS Toolkit or that they have MKS Toolkit or Cygwin (etc.) installed to emulate the UNIX environment, the other that they want to remotely execute a...

D:DataStage can never be a command, I don't care how many prefixes you add to it. It's a Folder, pure and simple. What precisely are you trying to achieve? The best practice with scripts (or BAT files) is to use full pathnames. If you can't do that, use CD commands to get you where you need to be - ...

Where did you hear that rumour?

It's not particularly true except to the same extent as most other stage types - too many of anything will overload the machine. Too many jobs executing at the same time will overload the machine.

Nothing to prevent you from using lower-level job sequences where necessary. A job sequence is just another job type; it can be run from a Job activity.

On that basis I am not even going to address your other question.

I can't know if you're wrong without seeing default.apt

I agree about Unconditional trigger.

You might create a second link with a Failure trigger, if you want to handle the Abort result specifically, for example by sending email.

It is a fundamental tenet of databases (and hashed files are implementations of database tables) that internal storage order is not under control of the user. Therefore you can not claim "the sequence which they are present in the hash-file (sic)". The Select statement returns keys in whatever order...

A hashed file is a database table, not a file. Therefore there is no need at all to use a link collector or any other way to assemble all the streams into one. Use three Oracle queries each writing to the same hashed file but on three parallel links. Locking occurs only at the record level, and only...

Have you installed the xpsp2 patch for DataStage client? You obtain it from your support provider.

Avoid using the optional OVERWRITING keyword - it can cause you silently to trash important words in the DataStage vocabulary, a situation that is incrediby difficult to diagnose.