isNull( ** variable, ** ifnullvalue ) return boolean

** = all data types

The purpose of the isNull function is to introduce a PowerScript equivalence to database functions like Microsoft Sql Server ISNULL, or Oracle NVL functions.

It allows to code more concise and less error prone null value checking code than ;

if isnull( as_value ) then as_value = "N"'
if as_value = "Y" then
...
else
...
endif

by :

if #.isNull( as_value, "N" ) = "Y" then 
...
else
...
end if


Last edited Jun 1, 2015 at 9:52 PM by domangep, version 5