no rows as a result

[master_student]

Hello Guys,

I need your help.

I have sql query that runs on green plum (SGBD) but whene i put in in qlikview the script execution finich without returning any rows.

please see the screen bellow :

here's the query :

select

SUBSTR(s.telephone_number, 4, 😎 as "Concern. MSISDN",

p.offer_name as "offer"

from p_xx_offer o

left join p_edxxriber s on o.subscriber_id =s.subscriber_id

left join p_edxxffer p on p.offer_id = o.offer_id

;

whene i add limit in the query it runs in qlik view

any idea on how to solve this issue please. I really need your guide

Thanks

[master_student]

i dont post the second conncetion, I use oracle

[Anonymous]

Does the sql statement work, when using another tool instead of QlikView.

...for example Oracle SQL Developer?

[Anil_Babu_Samineni]

I am not sure. But, It may not the issue to get reload and fetch the DB. You may wrong connection or those are not existing. Can you test connection whether it is succeed nor not

[master_student]

the query work on green plum

[master_student]

the connection works well

[Anonymous]

I never used green plum.

Does it also use an ODBC Connection?

[master_student]

yes

[Anonymous]

Did you try to create a view where all joins are done an then load the data from the view?

[master_student]

how? i think it's problem of number of rows because whene i limit the number of rows to 1000 for example it works, perhaps the solution is to increase the amount of RAM on the server ?

Thanks

[Anonymous]

If you created a view at the oracle server, then you could just read the fields with a relatively simple select statement and then be sure, that it is no syntax problem.

Select A, B, C, D , E  from YourView...