DSXchange

Add two more Execute Command stages to capture the time. This will give you the actual script execution time. Anything else is DataStage overhead, and the overhead of starting a new shell for each command.

Startup time of the job, probably. Enable player timings and display of startup to confirm.

It probably is simply allowing two extra digits of precision (without changing scale) on the premise that the sum will be larger than any of the individual elements of the sum and, as a rule of thumb, allowing the sum to be about 100 times larger than any other element. (And that at the lower bound ...

Does anyone know for sure whether the Round Robin algorithm in the Link Collector stage is a "hungry" round robin or whether it waits if an input is not ready?

I'm sketching out a design waiting for DataStage to be installed, so can not test this.

The logic is very similar. Play with the delimiter character and occurrence value arguments.

Look for the pxEreplace() function on DSXchange. This will allow you to change "|" to " on " with a single function call.

Is this one of the ones you can both have and eat?

srivalli_b wrote:my dataset does not contain any rows. When I am tried to view data it is not showing any records.

That seems entirely reasonable.

You need a better strategy, perhaps dsrecords -n command, in your sequence to determine the number of rows.

They're pretty close to identical in terms of performance. What's different is the functionality - with the Remove Duplicates stage you can specify which record to keep from each group (first or last) whereas with a unique sort you cannot specify which record to keep from each group.

Are you able to re-compile the 2nd job in Designer? If so, does it then show up in Director?

Help us to help you. What's different about Bulgarian data - accented characters perhaps?

Probably because the command was typed in rather than using the expression builder and/or because parameters were included in the Command field (they may only appear in the Parameters field). These are my guesses. I don't know for certain what the OP did.

Can WSDL now be imported via HTTPS ?

Did you read my reply last time you posted this question?

Then the answer to your question is "Yes".