SAND CDBMS Tools Reference Guide
NDL++ Functions: Syntax and Examples

Return to String Function Index

 

String Function Syntax and Examples

ISNULL( )

The ISNULL() function determines whether the specified field contains a NULL value (as specified with the NULLIF clause in the load specification script). If the column contains a NULL, the function returns 1; if the value is not NULL, the function returns 0.

Syntax:

ISNULL(field-label)
 

Example:

input: NULL

IMPORT @sample.dat
{

RECORD
{
field1 *\r\n NULLIF field1=='NULL'
}
schema1.table1
{
col1 ISNULL(field1)
}

}

Results:

schema1.table1.col1

1

 

Return to String Function Index