Script result nothing

[master_student]

Hello Guys,

I really didn't get why my script doesn't work.

here is he script :

ODBC CONNECT32 TO vv_vv;

NoConcatenate

F_temp:

select

Tel,

p.off as "offer"

from p_edw.sub_off o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (current_date -1 between valid_from and valid_to );

exit script;

the result is nothing :

any help please

Thanks

[master_student]

green plume is a dbms and the p is fixed in my query

[Peter_Cammaert]

You mean Greenplum dbms? That dbms is PostgresSQL-based and therefor has a query tool called psql. You can test your queries by starting psql with the name of your database, and then running the same query by copy/pasting it at the command prompt.

[master_student]

thanks but it doesn't solve the pb