How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo.
This is in SQL:
DECLARE @curr varchar (10);
SET @curr = 'USD;
Currency = @curr;
I have tried something like this in Denodo
Currency = GETVAR('curr', 'VARCHAR', 'USD');
But is not showing results. Does anyone know how can we do something similar to SQL variable declaration in Denodo?