HANA SQL- IFNULL & NULLIF Function

IFNULL()  and NULLIF( )- Function

---

The test program that calls the AMDP method.

IFNULL( )- Function accepts two arguments and if the first argument value is NULL then it returns the second argument and  returns first argument if the first argument is NOT NULL.

NULLIF( )- This function accepts two arguments and if they are equal then it returns NULL value else it returns the first argument.

---