Q&A BY TAG 'Interpolation Variables'

You must sign in to ask a question. If you do not have an account, you can register here

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

Interpolation Variables param default value IN cl

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

Base view Interpolation Variables variable

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

Interpolation Variables

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 Variables Password

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

Function oracle Interpolation Variables

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

Interpolation Variables

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

Interpolation Variables

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

Interpolation Variables

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

Interpolation Variables