I need to use nvl function and I get this error
(FOC1400) SQLCODE IS 195 (HEX: 000000C3) XOPEN: 42000
: Microsoft OLE DB Provider for SQL Server:  'NVL' is not a recogni
: zed built-in function name.
here is my data:
I need following: decode(SALES,null,TAB2_SALES,SALES). I figured that
decode is not working in my version of FW as well, so I will be useng CASE and "SALES" column is a number, so I need NVL . What would be a correct syntex to code that Logic?
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
If you use CASE logic, is NVL needed?
SELECT ... , CASE WHEN SALES IS NULL THEN TAB2_SALES ELSE SALES END AS SALES FROM ... ORDER BY ... ;
|Powered by Social Strata|