Filtering using a temporary field 1

[PeterG5]

Hi All,

It's all a bit new to me and I know how to do this in other
languages, so can anyone please help me?

I want to define a temporary field and then use it as a
filtering condition, like this.....

SELECT (SNAP.SO_VIEW_ID ||
SNAP.SO_STATUS_LAST_ID ||
SNAP.SO_STATUS_NEXT_ID) AS MOJO_FILTER,
etc, etc,.....

WHERE (MOJO_FILTER NOT IN ('S620999', S900999')).....

DB/2 SQL does not seem to like this.....

Many Thanks,

Peter.

 

[PruSQLer]

You can't define a temp field in the select and use it in the Where clause. What I would do is use a temporary table expression:

With mojo_filter(ID)
As (
Select SNAP.SO_VIEW_ID ||
SNAP.SO_STATUS_LAST_ID ||
SNAP.SO_STATUS_NEXT_ID
From snap )

Select so_and_so
from mojo_filter
where id not in ('S620999', S900999')