Select value clause

arijitlovesall · New User Joined: 07 Jul 2009 Posts: 2 Location: Chennai

I came across a query like this :

SELECT VALUE(SUM(COL1),0)
INTO :WS-VAR1
.........................

Can anyone let me know what the VALUE(SUM(COL1),0) clause does actually.

Thanks

dick scherrer · Posted: Mon Oct 04, 2010 8:45 pm

Hello,

Suggest you try the query in spufi (without the host variable). . .

GuyC · Posted: Mon Oct 04, 2010 9:20 pm

or look up value() in the manual.
It does the same as coalesce()

One thing to keep in mind is that "select sum() from tab where ..." returns null when no rows qualify the where clause