Hi, I am facing an issue where using an interpolation variable in where condition of a dervied view. The views is something like this: CREATE OR REPLACE VIEW V1 AS SELECT Col1, Param1 FROM T1 WHERE Col2 = Param1 USING PARAMETERS (Param1 : text '12...
Answers:
1
Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...
Answers:
1
Hi, I want to to pass a dynamic value as filter in where condition. I am try column1 =@input_value_for_column1 can you suggeset as why its not working, do we need to do anythign else to use interpolation variable or to pass the value dynamic in the w...
Answers:
3
I have two web service data source which expect the user name and password to be passed as part of the POST body. This is easy to make work with interpolation variables but is far less than ideal. Is there a method where the configured credentials c...
Answers:
5
I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...
Answers:
1
I have first base view with interpolation variables. I would like to pass values for them from second base view. To achieve this, I have created a derived view joining first and second base views. it is working fine until there is a null value in one o...
Answers:
1
Hi, I am connecting Tableau to denodo view which has interpolation variables which is needed by the datasource to create the dynamic http link. Not sure how i can pass those values from tableau to denodo. Thanks,
Answers:
1
Hi team, I am trying to create a base view from a query based on an interpolate variable within the FROM clause. (SELECT * FROM {schema}.@TABLENAME). I want to do this because the platform I am trying to reach (OutSystems) uses a database with 2 layer...
Answers:
1
Dynamic Interpolation Variables joining of interpolation variables OutSystems
Hi I am new to Denodo .. i want to create a web service for my table’s join view, But how shall i pass the input values from my program which will call that web service to the Where clause of the query? how do i declare/use/;map the input data to my w...
Answers:
1
Please help. Query 1: Select * from classicmodels.orders where status in (@input_status) During execution I am passing input_status in '(select "Disputed" from classicmodels.orders)' and getting correct result. But .. Query 2: Select * from cla...
Answers:
1