Latest Activity

code

Case statements not giving expected results in Denodo

When I execute the below logic in TOAD in the SELECT statement, I get proper expected result but when I put the same logic in Denodo View for one of the output columns, the result set doesn't match with what Toad is returning: ((((trim(tr_tran_short_d...

CASE

code

How many CASE statements are allowed in one view?

Hi I have a question regarding the CASE statement and how many can be used in creating a view. I have two views joined in a UNION. I have multiple fields where I have applied the following statement: Case WHEN (view1.field1 is null) THEN view2.fiel...

UNION CASE