SQL IsNull

Jacob — Sat, 16 Nov 2024 21:41:12 GMT

Hi All ,

I am fetching data from SQL.

When i am loading below script i am getting error.

Srcript:

Table;
LOAD  data,
      ---
      ----
sql SELECT DATAID,DECODE(NVL(STORE_NUMBER,'*'),'*',SAGE_WH,STORE_NUMBER) AS STORE_NUMBER,SUPERVISOR,AREA,COMPANY,STATUS,CATEGORY FROM list 
 where REGION IN ('USA','UK','IND','PAK','AUS') AND COMPANY = 'RETAIL' order by STATUS desc ;

Error:

Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'NVL' is not a recognized built-in function name.: sql SELECT DATAID,DECODE(NVL(STORE_NUMBER,'*'),'*',SAGE_WH,STORE_NUMBER) AS STORE_NUMBER,SUPERVISOR,AREA,COMPANY,STATUS,CATEGORY FROM list where REGION IN ('USA','UK','IND','PAK','AUS') AND COMPANY = 'RETAIL' order by STATUS desc

Re: SQL IsNull

swapniltaz — Mon, 31 Dec 2018 06:24:59 GMT

The NVL( ) function is available in Oracle, and not in SQL Server.

This function is used to replace NULL value with another value and the ISNULL Function in SQL Server is used to obtain same functionality

topic SQL IsNull in App Development

SQL IsNull

Re: SQL IsNull