Coding SQL in RPG

Hi,



I have an RPGSQLE programme and I want to code several similar statements.



They have a common WITH expression and only a difference in a GROUP BY
clause :



Exec sql

With t as (

SELECT etc with the same host
variables

)

SELECT etc

FROM t

GROUP BY (clause1 or clause2 ….)

End-exec



What is the best way to code this ? I seem to remember that having several
copies of the statements instead of building them during run time is
actually more efficient.