dec(9,2) and keychange problem.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

dec(9,2) and keychange problem.

Post by ds_is_fun »

Im trying to perform a business logic where I sort on columns.
Then I use the keychange column.
Im trying to catch a column which is a decimal(9,2). If this value = 0
Then I say target column = keychange * -1.
Now the target column is also defined as a decimal value. The keychange out of DS is TinyInt.
The logic doesnt seem to perform well.
It seems to catch all decimal(9,2) as 0 and also non-zero values as 0.
What is the best conversion I should use for this.

If col1(dec9,2) = 0 Then 0
Else keyChange(TinyInt) * -1

Thanks!
Post Reply