DSXchange

User defined SQL

Try disabling server-side tracing.

Try the field width property rather than the max width property.

A "processing node" is a logical concept - a subset of your available processing power and resources such as memory and disk. The degree of parallelism is determined by the number of nodes defined in the current configuration file. It is unrelated to the number of CPUs - it may be less, it may be sl...

It is not possible with a Job activity.

It is, of course, possible with an Execute Command activity.

But why?!!

DataStage repository tables are deliberately bereft of metadata. This is primarily because "they" make use of the non-first-normal-form features of "UniVerse" to store objects and collections of objects, which can not be readily access via SQL. The other reason, of course, is to discourage hacking t...

khanparwaz wrote:

ray.wurlod wrote:You must be in the parent directory.

Code: Select all

cd $DSHOME
. ./dsenv
bin/uvregen

You must also be the DataStage administrator. ...

Hi ray , thanks for reply.

i am doing it from bin directory only.

And that is 100% wrong!

Two nodes is exactly right for a development environment. If it works on two it works on more. Number of CPUs is irrelevant - sufficiently complex jobs will use all of them even with two nodes, in an SMP ("shared everything") environment. Use two readers per node when reading the file. For larger fi...

Aggregator stage always generates a dfloat. There is a "decimal output" property, but this must have at least 12 digits of precision to avoid the error. Or simply accept dfloat as the output column from the Aggregator stage and change it explicitly in a downstream Modify or Transformer stage.

What's different between the one that works and the one that does not work?

"Nothing" is not the correct response.
Investigate.
If you don't find a difference, investigate more thoroughly.

What diagnostic information is written to the TMU log file?

Evaluate each condition in a separate stage variable and use further stage variables to effect the Boolean combination of results. Use as many output links as you require for the different conditions. Write these to separate files and combine them later (with cat, perhaps) or use a Link Collector to...

In what order do you want to run them? There is no command like dsjob -run * if that's what you're looking for. But you could do something like for j in `dsjob -ljobs project` do dsjob -run -jobstatus options project ${j} done (all on one line if desired). Of course you will have no contro...

You must be in the parent directory.

You must also be the DataStage administrator.