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

[Anil_Babu_Samineni]

Simple try to load DB data and then we can discuss related on SUBSTR

[master_student]

same thing @Anil. it runs without returning anything

[Anil_Babu_Samineni]

1) This case, May be DB don't have values.

2) Or you may doing wrong load source. Can you share full script if possible

[master_student]

the database has values

ODBC CONNECT32 TO SxxxD;

left join(FAIT_CASES)

select

s.telephone_number as "Concern. MSISDN",

p.offer_name as "offer"

from p_edw.subcriber_offer o

left join p_edw.subscriber s on o.subscriber_id =s.subscriber_id

left join p_edw.offer p on p.offer_id = o.offer_id

where ('02/03/2017' between valid_from and valid_to )

;

exit script ;

[Anil_Babu_Samineni]

Can you post this directory code / Script, please FAIT_CASES

[master_student]

FAIT_CASES:

LOAD

"Entité",

xxxxxxxx

"MSISDN_APPELANT"

;  

SELECT

xxxxxx;

ODBC CONNECT32 TO SxxxD;

left join(FAIT_CASES)

select

s.telephone_number as "Concern. MSISDN",

p.offer_name as "offer"

from p_edw.subcriber_offer o

left join p_edw.subscriber s on o.subscriber_id =s.subscriber_id

left join p_edw.offer p on p.offer_id = o.offer_id

where ('02/03/2017' between valid_from and valid_to )

;

[Anil_Babu_Samineni]

What if output comes with below script. And Connect should always First line of Source data(I mean before source data only you need to connect to DB). And are you forcing 32 bit and can you let me know the Which DB you are using?

ODBC CONNECT32 TO SxxxD;

FAIT_CASES:

LOAD

"Entité",

xxxxxxxx

"MSISDN_APPELANT"; 

SELECT

xxxxxx;

[master_student]

the two queries from different databases

the second data base that didn't return anything unless i add limit in the query is green plume (i am forced 32 bit )

[Anil_Babu_Samineni]

I am sorry, I can't help much. Out of offers. Because, you are talking about 2 DB's and you have single connection. Does you mean two tables? I am sure, It may 2 Databases so then you should to use 2 connections and then simple reload then data should come even simple connection, Green plum is one and what is the another one over here.