fillnull command: Overview, syntax, and usage
The SPL2 fillnull command replaces null values with a specified string value.
The SPL2 fillnull command replaces null values with a specified string value. Null values are field values that are missing in some results but present in other results.
Syntax
The required syntax is in bold.
fillnull
[value="string"]
[field-list]
Required parameters
None
Optional arguments
field-list
Syntax: field, ...
Description: A comma-separated list of one or more field names. If you specify a field list, all of the fields in that list are filled in with the value you specify. If you specify a field that didn't previously exist, the field is created. If you do not specify a field list, the value is applied to all fields.
value
Syntax: value="string"
Description: A string value to replace the null values. The value must be in double quotation marks. The value can't be a field name. If you do not specify a value, the default value is applied to the field-list.
Default: 0
Usage
You can specify a string to fill the null field values or use the default field value, which is 0.
See also
fillnull command