champs introuvable

[master_student]

Hello Guys,

I got this error "champs introuvable". bellow is my script :

test :

LOAD  "MSISDN",

"OFFRE"

;

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to );

exit script;

Any idea please?

[Peter_Cammaert]

You could temporarily omit the Preceding LOAD, execute the SQL code and inspect your table in Table Viewer (Ctrl-T). The fields returned from your DBMS may have different spelling, even if you rename them all to uppercase in the SELECT statement...

[master_student]

whene i execute the query without the load. it doesn't return any row. here the result :

here is the script :

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to );

exit script;

and whene i add limit in my query. it runs :

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to )

limit  1000;

it retunrs 1000 rows

whene i delelt the limit, it returns this error :

File extdata.cpp, Line 2903

Any idea pleaseee

Thanks