Klemens wrote on Thursday 03 July 2003 18:43:
> I try
> INSERT INTO TAB1 (COL1) SELECT VALUE(SELECT_STMT1, SELECT_STMT2) FROM TAB2
> Why is SELECT_STMT2 executed even if SELECT_STMT1 returns a NOT NULL value?
> I tried to workaround with:
> CASE WHEN SELECT_STMT1 IS NULL THEN SELECT_STMT2 ELSE SELECT_STMT1 END
> But here SELECT_STMT2 again was executed while SELECT_STMT1 returned a NOT
> NULL value
> The problem with this behavior is that I have data where SELECT_STMT2
> returns more than 1 row but only while SELECT_STMT1 returns 1 row. So if
> SELECT_STMT2 ...