DSXchange

Or there may be an expression that takes the square root of a negative number - well, attempts to - in the Transformer stage in question. One ought never to leap to conclusions during diagnosis.

V 0.4

OK, not impossible, but insane if the reference column has many rows.

What is the format of the data in the character string that you are reading? Use this as the format string in a StringToDate() function. Use that result in a DateToString() function, this time specifying the desired output format. The function calls may be nested.

What Teej really needs to see, rather than all that "how to use sqlplus" waffle, is the output of echo $DATABASE to prove whether or not the environment variable has been assigned a value.

There is a manual (white paper?) on DB2 connectivity from DataStage, and setting it up. This should be available through your support provider, as it was created by IBM's support group originally.

It is impossible - on either system - to have a reference link without a key column. How would you specify which row(s) to return?

This is version 8, and there is more in the job report than I expected. TO test whether it's RCP or not should be simple, just disable it and see what happens. Other than that I have no further theories to offer, and am not in a position to test any of them this week even if I did. But, wait! What d...

And so you see that it is only large numbers that are losing precision. You need to investigate further to determine where the cutoff point is, then that number might of itself tell you something about the underlying algorithm(s).

Send large pots of money to IBM (through your vendor) for an Enterprise Edition licence for parallel jobs.

If your data are key-partitioned on the sort keys (hash or modulus algorithm) every distinct value will occur on one and only on one partition, so that your entire data set is sorted no matter how many degrees of parallelism you use.

... but not unintelligently!

Search the forum. This has already been answered too many times. Ask your DBA about WITH NO LOG.