Re: Conditional SQL processing against host variables

The final code is this, and it does seem to operate more efficiently.

if pmDevice='*ANY';
hvDevice='SCN%%%%%%%';
else;
hvDevice=pmDevice;
endif;
if pmUserID='*ANY';
hvUserID=*all'%';
else;
hvUserID=pmUserID;
endif;
Exec SQL
declare C1 cursor for
select replace(THWS,'$',' '),
THUSER,
TTDTE,
max(THTIME)
from ITH
where TTDTE>=:YearAgo
and tHWS like :hvDevice
and tHUser like :hvUserID
group by THWS, THUSER, TTDTE
order by TTDTE desc, THWS, THUSER;