Case in where-clause version dependent?

Hi,



I’m retrieving a list of libraries using embedded static sql like this:



exec sql

declare tctest08_cursor1 scroll cursor for

select objlib, objname, objtype, objowner

from table ( qsys2.object_statistics( 'QSYS', 'LIB', '*ALL' ))

where Case When :wildcard = '%'

Then objname like trim( :wxlib )

else

Case When :wildcard = '*'

Then objname = objname

else

Case When :wildcard = ' '

Then objname = :wxlib

end

end

end



for read only

;



Which works as expected if compiled at V7R5M0.

If compiled at V7R4M0 and below I get error:

SQL7906 30 5964 Position 38 SQL function not supported on prior release.

Function is - IS TRUE.



I need to get this compiled at V7R3M0 – is there any way to rewrite this CASE to work under V7R3M0?

Would prefer not to use dynamic sql….



Merry Christmas everyone



Stefan