Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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...
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