Hi All,
Can we create summary table with WHERE cluse and host variable? like this:
create summary table TEST as
select f1,f2,.....
where f1=:h1 and f2=:h2
...
...
...
from Orig-table
...
...
if the answer is yes my questions are
1- should I code the creation in application or create a script, if I create a scrpt how can I pass the host variable everytime?
2- if I code in application, everytime the variable is changed ,recreated the summary table?
3- anyway I have been confused with host variable with summary table

Thanks in advance for your co - opration.