Skip to main content Skip to complementary content

NullAsNull

The NullAsNull statement turns off the conversion of NULL values to string values previously set by a NullAsValue statement.

Syntax:  

NullAsNull *fieldlist

 

The NullAsValue statement operates as a switch and can be turned on or off several times in the script, using either a NullAsValue or a NullAsNull statement.

Arguments:  

Arguments
Argument Description
*fieldlist A comma separated list of the fields for which NullAsNull should be turned on. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

Example:  

NullAsNull A,B;

LOAD A,B from x.csv;

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!