DSXchange

"Compile in trace mode" creates a version of the job with a Peek on every link and the ability to run only a small sample of rows through the job design, without your needing to touch the design at all.

You're getting into the realm of unstructured data here, and that can only easily be done in DataStage using custom components. I've been on a couple of sites where emails of known structure were used as a source, and even that needed careful coding (in a Transformer stage in a server job).

No. Only one method of user authentication can be used.

Is Key_Col one of the join keys? Are the data partitioned on both inputs using a key-based partitioning algorithm that names the join keys? Sorted?

... and this should be done using a single job Why? To me the most eminently sensible, and most easily maintained, design is to use separate jobs with a sequence to make the decision about which one to run. These might be multi-instance so each user can run without needing to have regard to any oth...

Lots of ways. Probably the easiest is a Routine activity to verify the row count in the file against the file name.

If it's a small, finite number of partitions, multiple output links from a Transformer stage with appropriate constraints on each would seem to me to be the way to go.

Looks like something, somewhere, in your DataStage job is generating nulls. Perhaps failed lookups? You must scrutinize your job design with an intense scrute.

Ray, adding the Rotuine Activity within the sequence cannot help me to capture the EndTimeStamp of the sequence as technically the sequence is not complete until after the Routine Activity is completed. Isn't it? The same argument that applies to an after-job subroutine, isn't it? The times to the ...

We don't do ASAP. If you need a rapid response, sign up for priority service with your official support provider and learn just how much "urgent" costs. DSXchange is an all-volunteer site whose members post as and when they can. You have also hijacked an already resolved thread, another p...

What are the join keys? It's those on which the data have to be partitioned, or at the very least on the first of them*. However, the data have to be sorted on all join keys. * Why is this? If you partition on A alone, all combinations of A and B for any given value of A will be on the same partitio...

All of those values are valid for Decimal(20,10).

Stick some echo commands into the script to determine what the received command line arguments are. These can be removed or crippled once your debugging session is done.

Constrain outputs based on the value of the user ID (perhaps retrieved through GetEnvironment() call).

The present tense plural form of the verb "to be" is spelled "are", not "r". DSXchange is not a mobile telephone; there is no requirement to use SMS-style abbreviations. We strive for a professional standard of written English on DSXchange, not least because we regard ...