Hi i got the following error while compiling a db2 program .

What is the solution ?

an unexpected token "union select 'y' " was found following

"ff_dt > current date".

Expected tokens may include: "". Sqlstate=42601 and my query looks like this select 'y' into :ws-future-exist-sw from con01_cust_cntct where aid_cd = :ws-aid-cd-only and cntct_eff_dt > current date union select 'y' into :ws-future-exist-sw from con01_cust_cntct where aid_cd = :ws-aid-cd-comp and cntct_eff_dt > current date


this question asked by dinesh kumar