RE: function coalesce

Disclaimer: this question is better suited for sapdb.general, as it is about 
the features (existing or future) of SAP DB, not about how you would implement 
them yourself.

> we are trying to port our application database to SAPDB and found an 
> incompatibility issue to ANSI-92:
> 
> The function COALESCE is implemented in the query engine, but 
> does not 
> retrieve the correct results. Moreover, it generates an 
> error, when more 
>    than one column is SELECTed. However, we found the workaround with 
> the VALUE function.

There is no function COALESCE in SAP DB. The statement
select coalesce(c1,c2,c3), 1 from test
creates a result set named 'COALESCE' from the columns c1, c2, c3.

Named result sets are an alternate syntax for OPEN CURSOR.

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
[email protected]
http://www.sapdb.org/