Function ISNOTNULL

TABLE OF CONTENTS

  1. How do I use ISNOTNULL?
  2. Syntax
  3. Rules for the syntax
  4. Examples: ISNOTNULL function in ERF
  5. Examples: ISNOTNULL function in ECL

How do I use ISNOTNULL?

The ISNOTNULL function checks the specified field for null values. If it is not all null values, then ISNOTNULL returns true. If it is all null values, ISNOTNULL returns false.

The field can be a source field or a field from a lookup.

ISNOTNULL can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

(Syntax Legend)

Syntax

Function ISNOTNULL 1

Function ISNOTNULL 2

Function ISNOTNULL 3

Function ISNOTNULL 4

Function ISNOTNULL 5

Rules for the syntax

ISNOTNULL can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

If this functions checks a lookup, and no effective date is specified, the lookup uses RUNDAY( ) - see topic: Syntax - function RUNDAY

See also topic: Rules for all Logic Text

Examples: ISNOTNULL function in ERF

Example logic text Meaning
IF ISNOTNULL({field3})
    THEN SELECT
ENDIF		 Select all input records where field3 does not contain null values,
and skip all other records.
This example is the same as:
    SELECTIF(ISNOTNULL({field3}))
IF ISNOTNULL({Lookup1})
    THEN SELECT
ENDIF		 Select all input records where the lookup field for lookup path Lookup1
does not contain null values, and skip all other records.
This example is the same as:
    SELECTIF(ISNOTNULL({Lookup1}))

Examples: ISNOTNULL function in ECL

Example logic text Meaning
IF ISNOTNULL({field4})
    THEN COLUMN = {field4}
    ELSE COLUMN = “NOT AVAILABLE”
ENDIF		 If field4 for the current record does not contain null values,
then set the current column to field4,
otherwise set the current column to “NOT AVAILABLE”.