April 19, 2010, 11:04 AMvkrugman
Using NVL sql function in MRE WF- problems
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?
April 19, 2010, 02:14 PMDan Satchell
If you use CASE logic, is NVL needed?
SELECT ... ,
WHEN SALES IS NULL THEN TAB2_SALES ELSE SALES
END AS SALES
ORDER BY ... ;