Q&A BY TAG 'Paramaterised Query'

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

Parameterized View
answered 29-06-2020 07:30:40 -0400

Hi, I have two different data souce connected in Denodo (one is Netezza and one is Oracle). I have created one baseviews in both the sources using query.(i.e. net_baseview and orc_baseview) net_baseview has some paramteres (start date and end date an...

Answers: 1

Paramaterised Query

View with input parameters
answered 29-06-2020 03:49:06 -0400

Hello Team, Consider my scenario. So i have query something like this. WITH userdata AS ( SELECT id from user where user_name in (user_list) and user_status='Active' ), payment as( select * from payment where payment_status=1 and payment_user in (sel...

Answers: 1

Paramaterised Query

Parameterised query Problem with IN clause when passing Array of String
answered 15-05-2020 09:30:58 -0400

Hello, I am stuck at one point while working on Denodo REST Web Service. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am pas...

Answers: 1

array of string Paramaterised Query In Clause

Parameterised Query
answered 26-02-2020 03:40:42 -0500

Hello, I came across one issue. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am passing through GET request when i am callin...

Answers: 3

Paramaterised Query In Clause