Satish wrote:
> I get the following error when i compile the view given below.
<snip>
... then select ...
Scalar subqueries need to be in braces:
then (select ..... )

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab