Calculation view with multiple selects using sql script

Hi All,

I am trying to implement a logic where there are multiple selects which perform filtering and evaluate other conditions to get the result.

As a small example, i fetched the result of first select into "var_out1" and then did a simple select from it into "var_out".

On validation i get the error "var_out1 does not exist in SYSTEM schema".

Any suggestions on how to deal with this??? As there would be multiple selects into different variables in the program.

Thank you,

Preeti