How to declare a variable in denodo?

veeraravala
Occasional Contributor

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;

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?

1 REPLY 1
KirillKuznetsov
Certified Master Anaplanner

Hi @veeraravala 

To my knowledge Anaplan has no relation to Denodo product. I am afraid you have used the wrong forum to ask that. Try to find Denodo related forum in the web. 😊

Regards, Kirill Kuznetsov
Advanced, LLC