Skip to main content Skip to complementary content


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


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.


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.


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!