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:  

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;

See also: