To specify that empty fields are to be treated as NULL.
Format
/NULLIF null_specification [, null_specification . . .]
where
| null_specification | = | {CHARACTER} {NUMBER } {DATETIME } | EMPTY |
Location
The option may appear anywhere in the task definition.
Notes
Edited numeric (EN)
Scientific notation (SN)
Decimal, embedded leading sign (LZ, LP)
Decimal, embedded trailing sign (ZD, TP)
Decimal, separate leading sign (LS)
Decimal, separate trailing sign (TS)
Decimal, unsigned (AN)Delimited fields are considered empty when they have a length of 0 (two delimiters next to each other), or when they are filled with spaces and/or tabs. Positional fields are considered empty when they are filled with spaces and/or tabs.
If this option is not specified for a specific data type, all displayable source fields of that data type will default to being not nullable.
Nullability can also be set on a per-field basis, as described in /DELIMITEDRECORDLAYOUT and /RECORDLAYOUT.
Example
/nullif number empty/nullif character empty, datetime emptyBy default, all empty character and date/time source fields are treated as if the value is NULL.