Q&A BY TAG 'Interpolation Variables'
Denodo interpolation/parameter issue while using IN clause
answered
04-02-2020 07:07:55 -0500
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
Create BV with variable
answered
14-11-2019 06:04:52 -0500
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
how to use a interpolation variable in where condition of a derived view
answered
14-11-2019 04:46:49 -0500
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
Credentials in message body?
answered
23-09-2019 01:03:34 -0400
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
Interpolation of function and variable.
answered
26-09-2018 08:27:23 -0400
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
Interpolation variable - Passing value from another base view
answered
24-08-2018 02:57:02 -0400
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
Denodo connect to tableau
answered
28-02-2018 04:52:49 -0500
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
Using an interpolate variable in FROM clause
answered
05-04-2017 08:23:19 -0400
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
Interpolation variables ? How to add runtime query view in Denodo?
answered
31-10-2016 05:29:23 -0400
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
Pass list of value to an interpolation variable
answered
08-09-2015 04:55:47 -0400
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