I need to create an sql view in DB2 using dbeaver.
This view will use variables that are results of other sql queries run upstream.

example query 1: select champs1 frome table1 ===> store value in var1

use of this variable :

select * from table2 where field2 > MMRGDT>(year(current date – var1 days)*10000 + month(current date – var1 days)*100 + day(current date – var1days))