NotNull IsNull
Posted: Thu May 05, 2005 6:39 am
Not Nulls
I have a situation where some columns coming in after a lookup against lookup filesets are Nullable = 'Y'. The current business logic does'nt help much to default them to a specific value implicitly if NULL. Rather, it performs a check greater then or + or lesser than for certain values on those columns.
If I use the NotNull(column) and perform those checks, would it help to get rid of the WARNING message on those columns and avoid possible termination? Instead of If IsNull(col1) then "NA" Else <expr1>
Thanks!
I have a situation where some columns coming in after a lookup against lookup filesets are Nullable = 'Y'. The current business logic does'nt help much to default them to a specific value implicitly if NULL. Rather, it performs a check greater then or + or lesser than for certain values on those columns.
If I use the NotNull(column) and perform those checks, would it help to get rid of the WARNING message on those columns and avoid possible termination? Instead of If IsNull(col1) then "NA" Else <expr1>
Thanks!