How to declare a variable in denodo?

Options
veeraravala
veeraravala Member, ALL USERS Posts: 4 Occasional Contributor
in Extensibility

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;

SELECT
Country,
Currency
FROM
Currencies
WHERE
Currency = @curr;

I have tried something like this in Denodo

SELECT
Country,
Currency
FROM
Currencies
WHERE
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?

Tagged:

Categories